Jun 07 2023
Need to get multiple Columns under row level in the Pivot Table.
Example data that you can make use of
When we create a pivot table and add up the columns "Is Customer Registered?" and "Is Customer Active?" to the Fields, we see a combination of it. However what is required is in the format
Is Customer Registered?
Is Customer Active?
Unfortunately this is not the format we get the data in. Any help?
View best response
Jun 08 2023
@siddll Perhaps something like in the attached file?
I flattened the data with Power Query and then loaded it directly into two example pivot tables. Does any of this meet your requirements? If not, please clarify how you want the result to look like.