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 :)

2 Answers

Perhaps if you added columns to your original table, and then Pivot those columns, you could get something like what you want:

Formulas:

E2: =N(Sheet1!$D2="Disabled")
F2: =N(Sheet1!$D2="Enabled")
G2: =N(Sheet1!$C2="Disabled")
H2: =N(Sheet1!$C2="Enabled")

Fill down.

Then create your pivot table: (Note that you will want to use the SUM and not the COUNT function)

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