by Matt Allington I was helping a friend out recently with an interesting problem. It all started with a SUM( ) that wasn't behaving. It quickly became a SUMX( ) problem but evolved into a DAX Studio/Query problem. Let me…
Let’s start 2014 with a bang…
I’ve been dying to write this post for awhile now. Let’s say you want your grand totals to appear at the top of your pivot, like this:
Grand Totals at the TOP of the Pivot? Yep, no problem.
Typically you’d want to do this when your pivot is really “tall” – lots of rows – and you don’t want to force people to scroll down in order to see the grand total.
Pivots do NOT let you display grand totals at the top of the pivot – only the bottom – so a frequent workaround is to write a formula in Excel itself that sums the whole column of the sheet. Very clumsy, and damn near impossible when you have two fields on rows like above.
How DO You Do It, Then?
The trick is simple – add a dummy table to your Power Pivot data model: