Attaching excel sheet with sample data I want to show top 5 dynamic , like if user select Customer then top 5 customer , if user select top 5 Brand then it should show top 5 brand in chart.
Any idea how to achieve this in sense ?
Thanks in Adv
Solved! Go to Solution.
I don't really get what u're trying to do; u have a measure; and each time u selecta dimension; u show the top5? is that so?
If that's the case; continue to do what's u're doing; just limit ur dimension:
Thanks , I wanted to display 5 ( Sales Amt , Growth % , etc..) top N by measure now when i select on measure then in growth % column i am getting 0.02423689281006 every row but at right side i have calculated correct growth numbers that should appear in dynamic top table.
Hope you understand now I want to show dynamic top measures on chart please see attached top chart result.png