•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Column Subtotals in Power Pivot
I have a basic Power Pivot table fed from a single data source. There is a field for Actual and Budget and a single field for values.
I am trying to lay my table out so I have a set of Actual numbers with a column field and subtotal, then a set of Budget numbers with the same column field and subtotal. Rinse and repeat for the variance column.
The issue is I can only add Grand totals out to the right. I cant get that total /subtotal column positioned with each set of numbers. Short of making a measure for each column, is there a better way? I feel like I'm overlooking something simple.
[link] [comments]
Want to read more?
Check out the full article on the original site