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.
...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.
Can you upload the workbook in which you added the LOD to the TOP N.
I am not able to get it done.