
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Top 10 required
Dear Gurus,
I have an urgent requirement. Attached the sample data and qvw
I am able to achieve Top 10 in Table 1 for HR, but same thing in Table 2 I need to achieve but expression should be grouped.
So when user select cyclic group “User” and expression Cyclic group “TV” in table 2 attached TV should be the result
So when user select cyclic group “User” and expression Cyclic group “TC” in table 2 attached TC should be the result
So when user select cyclic group “User” and expression Cyclic group “HR” in table 2 attached HR should be the result
Thanks in advance and please do let me know in case of any clarification
- Tags:
- aggr
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Used “Gysbert Wassenaar” reply from below link

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please check the attachment. If it meets the requirement, then I can explain how I did it.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Angad,
Thanks for your reply but attachement is not what i required, we cannot have Top 10 for Nov 2013 itself we have Dec and Jan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try clearing the selection, current in my attachment it is selected as Nov 2013.?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Used “Gysbert Wassenaar” reply from below link

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was unable to do this on dashboard.let me share one xsl file.In that i wanna calculate top sales of product.I used dimension as product in Bar chart and i used the expression as =if(aggr(rank(sum(sales)),product)<=5,product).It is showing no data found.If that is the case i deleted that expression did sum(sales).And in dimension limit i used show largest 5 values.It is showing only 4 products values and 5th is other.What about the 5th product.I need to get that 5th product even.We need to go for exactly the finite number of choice then that is the case what is the solution.In this case i have go with that expression.But its not working.
Can any one please tell me the steps how can i solve this problem?
