Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @Ffitzpatrick47,
Could you please send sample data ( easy to manipulate) with your expected requests then we can try to help.
Thank you.
Ninter
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.
User | Count |
---|---|
88 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
91 | |
74 | |
68 | |
63 |