grand totals

[Ffitzpatrick47]

I made this TOTAL by hand, and would like to have the pivot table just automatically do it for me:

The amounts in there are all just sum(table[data]), so no fancy calculates.  This all comes from one fact table with a date dimension up top. The current Grand total just totals all the due and promise amounts as one number and that doesn't help me because I need to compare the two.

[Interkoubess]

Hi @Ffitzpatrick47,

Could you please send sample data ( easy to manipulate) with your expected requests then we can try to help.

Thank you.

Ninter

[Ffitzpatrick47]

Ok, but give me a couple days, this is a lot of data going through postgre pipes and I have to materialize it and make a dummy on the spreadsheet instead.