1 min readfrom 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.

submitted by /u/NotBatman81
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article