Use sub row only for certain head rows in excel pivot table from a cube

Viewed 14

I have the following pivot table:

enter image description here

Underneath "Sales" and "Gross Profit" I want to add a sub-row, which breaks down the figure by department. However I do not want "Other Income" or "Expenses" to be broken down by department. When I add department to the pivot as a second sub row, it shows like this:

enter image description here

Is there a way to only have the sub row under "Sales" and "Gross Profit"

Thanks, Scott

0 Answers
Related