Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have been searching and trying suggestions from other discussions but I still have not the result I am looking for.
I have a Pivot Chart with 2 dimensions, Category (Category) and Month (Maand) which looks like this:
What I try to achieve is to calculate the percentage of each category being used against the total amount.
However I am not able to sum a not listed category in addition to the ones listed to be able to do this.
The Chart Category dimension is setup like this:
If I use the following expression, it gives per month dimension the total of the 3 listed Categories:
But how to get the "not listed" Category also in this ? (The not listed Category is "Overig (w.o. Mipo)"
Thank you.
Try this
Aggr(NODISTINCT Sum(CA_TruckFacts.Rides), Werkdag.Maandnaam)
Hi Sunny,
Thanks for this, works like a charm!
Had to modify it like below to exclude the collected (instead of delivered) rows but with that added it does the trick:
Aggr(NODISTINCT Sum({<CA_TruckFacts.Trucknr={">0"}>}CA_TruckFacts.Rides), Werkdag.Maandnaam)
Have a good day!