
2. Re: Re: calculate the percentage difference between two colums that contains percentage values (from a quick table calculation)
. Indumon Oct 3, 2013 9:00 AM (in response to . Indumon)Sample workbook attached.

Total Variance.twbx.zip 45.1 KB


3. Re: calculate the percentage difference between two colums that contains percentage values (from a quick table calculation)
Markus Nosko Oct 4, 2013 4:59 AM (in response to . Indumon)Thanks a lot Indumon. Both for quick reply and a good answer that helped me out! :)

4. Re: calculate the percentage difference between two colums that contains percentage values (from a quick table calculation)
muthu.krishnan Nov 5, 2013 2:19 AM (in response to Markus Nosko)Hi,
By using quick table calculation we get the percentage of total.
Regards,
Muthu Krishnan. M

5. Re: calculate the percentage difference between two colums that contains percentage values (from a quick table calculation)
jonathan.o'grady.0 Jun 29, 2015 1:40 AM (in response to muthu.krishnan)Muthu,
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.
For example:
Total sales
By sales rep
By region
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.
Many thanks!
Jonathan

6. Re: calculate the percentage difference between two colums that contains percentage values (from a quick table calculation)
REMAX OntarioAtlantic Jul 8, 2015 6:34 AM (in response to jonathan.o'grady.0)We are also having the exact same challenge. Any ideas?