Here are some instructions on creating sets of the top customers, then utilizing this in a parameter with quick table calculations to find the percent difference.
1. Right-click on [Customer Name] in the data pane and select Create > Set…
2. In the Create Set dialog, do the following and click OK:
+ Name the set. In this example I will call it "Top 25 Customers"
+ Navigate to the Top tab
+ Select By field:
+ Enter 25 for the number of top members
+ Select Sales from the dropdown menu for fields
3. Create a calculated field with a name like "Percent of total for all top 25" with a calculation similar to the following:
IF [Top 25 Customers]
TOTAL( SUM( [Sales] ))
*Attached is sample workbook that explains the above solution in the caption. I would utilize this to create sets for each of categories that you would like to analyze.
percent of total for top 25.twbx 399.0 KB
Thanks for your reply with your attachment. Have seen your Viz and realized the usage of "set" which i never used before.
Actually I am almost near the end of my requirement BUT am unable to sort as desired.
Any chance looking into my attached file please and suggest where am going wrong or how to fix sort issue!
Top N v2.twbx 1.2 MB
What is the expected sort behavior that you are looking for? My assumption is that you would like to sort based on the metric. And currently it is sorting by state. Is this a correct assumption?
Yes i want the sort to happen on metric
Have used nested sort and got sort thing to work. please see attached.
But still there is 1 issue i am facing-
In the below screenshot #61k is not the top bar, its currently sorting within each group of state/city. Basically its not ranking sales i believe. Any insights please
Thanks for your time again!
Top N v2_Nested Sort.twbx 1.2 MB