Need Excel pivot table independent columns and no sub levels
Experts: Need an help - i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested.
I can surely create multiple pivot table but would be ending up having 10+. So is it possible and if yes how? I tried Google and looking through videos but they were of no help, so I'm finally writing a post.
This is how I want it to look:
Added a sample sheet and the pivot table that i get and how i want it to be :)
I believe you are looking for the report layout settings.Choose something other than "Compact" and you should meet your goal. "No sub-levels" can be obtained by clicking Subtotals
and Grand Totals
to the left of Report Layout