Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I can't seem to figure this out. I need a sum of rows in a pivot table. I am able to select sum of rows in a straight table but not in a pivot table.
This is the sum of rows I want:
I need a pivot table to have the same totals as above but don't know how to do it.
Thanks!
Use Sum(Aggr()) functions
Sum(Aggr(Expression, arsalesname, entrydate, rewarddate))
In Pivot table you need to select based on dimensions for each row from each dimension.
Use Sum(Aggr()) functions
Sum(Aggr(Expression, arsalesname, entrydate, rewarddate))
Hey guys, there is Help on this as well, just wanted to post for those that come here later and may have something that they cannot sort out, hopefully the Help info will do the trick in that case:
Regards,
Brett