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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#Power Pivot
#subtotals
#Grand totals
#Actual numbers