•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
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