thanks for that work - but now every Line is 20% ? This is not right. The total sum yes, but not the single lines. For example the first line should be:
(7000 - 5000) / 5000 = 40%
Thanks for that Zhouyi! Its working.
Could you explain to me, what the SIZE() Function is doing in this Case? Why is it true at 1?
This is a tableau build in function that calculate the size of partition, e.g. as below, the size of detail row is 7, if there is a grand total, the size of the total partition is 1.
In another word, I utilize this feature, apply different calculation when the partition is in total row.
Hope this makes sense.