This content has been marked as final.
Show 3 replies

1. Re: How to calculate Inverse of percentage of total
Brad Shuel Feb 10, 2016 5:34 PM (in response to yashwanth nekirikanti)Hi Yashwanth,
Are you able to provide an example workbook and a screenshot of the expected result?
Regards,
Brad

2. Re: How to calculate Inverse of percentage of total
Alfredo Pirrone Feb 10, 2016 8:45 PM (in response to yashwanth nekirikanti)Yashwanth,
Look at this example:
Percent of Total is defined as:
So, inverse of Percent of Total can be calculated as
These are "Table calculations" and the TOTAL function adds all values in the partition (the numbers in the view). That leads to the odd Grand Total of 100% for the Inverse Percent of Total because TOTAL(SUM([Measure])) = SUM(Measure) at the bottom line.
Hope this helps
Yours,
Alfredo

3. Re: How to calculate Inverse of percentage of total
yashwanth nekirikanti Aug 8, 2016 9:46 AM (in response to Alfredo Pirrone)Thank you