
1. Re: Total Top n as a percent of Total
Ivan Young Jun 17, 2016 7:28 PM (in response to Spencer Merrill)1 of 1 people found this helpfulHi Spencer,
You can create your own percent of total using LOD it should give the grand percent of total you are looking for.
Regards,
Ivan
SUM([Sales])/SUM({ FIXED : SUM([Sales]) })

2. Re: Total Top n as a percent of Total
Spencer Merrill Jun 17, 2016 10:39 PM (in response to Ivan Young)Hi Ivan,
Thanks for the response. I've actually tried that LOD calculation that you shared but the problem is that I am filtering by the Top 5 Cities by Sales. Since I am using a Top n Filter (using index()) I do not get a Grand Total. Therefore, when I apply the LOD calculation, I just get the total sales number. But what I need is the Total Sales Number by Top 5 Cities / Divided by the Total of all Sales.
Thanks, Spencer

3. Re: Total Top n as a percent of Total
Spencer Merrill Jun 17, 2016 10:56 PM (in response to Spencer Merrill)...Actually...the LOD calculation did work. I just had to combine it with my Top 5 Filter.
Thank you Ivan. I now have what I need.
Thanks for the response.
Spencer

4. Re: Total Top n as a percent of Total
Sumit Bhatia Jun 13, 2017 8:05 AM (in response to Spencer Merrill)Hi Spencer,
Can you upload the workbook in which you added the LOD to the TOP N.
I am not able to get it done.
Thanks

5. Re: Total Top n as a percent of Total
Alfredo Hermosillo Oct 27, 2017 1:02 PM (in response to Spencer Merrill)Hi
There are most than one solution, but i have this, i hope that ben what you find.
attach workbook with the solution.

TopNValueTotalValue.twbx 1.2 MB
