Thanks a lot Indumon. Both for quick reply and a good answer that helped me out! :-)
By using quick table calculation we get the percentage of total.
Muthu Krishnan. M
This answer is very helpful, thank you. However, I have a further nuance which you might be able to help me with please?
I am similarly trying to calculate the percentage difference between two calculated columns.
My issue is that I only have one measure. My columns are segregated by dimension.
By sales rep
The sales figure is the only measure I have. I would like to calculate the percentage difference between sales by sales rep at the regional level.
The solution you've posted above won't work. I've tried a look up but can't find an elegant solution.
We are also having the exact same challenge. Any ideas?