,
Hi All,
I have total of 50 customers .
But i want to display top 10 customer names, order quantity and amount.
I want sub-total for order quantity as sum of the top 10 customers order quantity and sub-total for amount as sum of the top 10 customers amount.
Under that i want to display order quantity grand totals as sum of all the customers order quantity and amount as sum of all the customers amount.
Please find the attachment for your reference.
Regards,
Reddy
Nagendra,
Sankar's method is one way to approach this but it does require an additional sheet to be used on a dashboard which can have potential negative impacts (performance, management, formatting/alignment).
This can be done with a single sheet utilizing a set for the top 10, a calculated field, and a bit of formatting.
- Create the top 10 set
- Create a calculated field similar to the one below to keep customer names if they are top 10 or to null them out if they are not:
if [Set 1] then [Customer Name]
end
- Place the set on the rows shelf and make sure it is set to In/Out
- Place the calc field on the rows shelf to the right of the set.
- Show column grand totals and all sub-totals (Analysis menu and then Totals)
Your view should look like this:
- Now, right click on the view where it says "Out" and click Hide.
- Finally, right click on your set on the rows shelf and uncheck "Show Header"
Your end result should look like this. Let me know if you have any questions.
Ken
