
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rank
Can we rank based on each dimension
for example.: I have a straight table with Cyclic Dimension and Sales Amount.My cyclic Dimension has the following below dimension.
Product
Product ID
Country
Sales Person
..
few more
So for example if i select Product | Sales Amount -- > The Sales amount should be ranking based on the top sold product
If i select Sales Person -------->The Sales amount should be ranking based on the top sales done on the Sales person
once i change the dimesnion it should be able to rank it.. i have totally 7-8 dimesnions which i would rank..
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you tried any expression or better approach if you share more information


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a variable to capture your group selection
say,
VGroupselection = GetCurrentField([GroupFieldName])
Now use this variable to aggregate your Rank expression
AGGR(Rank() , $(VGroupselection ) )
If a post helps to resolve your issue, please accept it as a Solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is the same of what I just explained!
If a post helps to resolve your issue, please accept it as a Solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ha it is, sorry I was obviously writing up as you posted. I'll remove my answer


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
oh no, I was expecting to see another method
If a post helps to resolve your issue, please accept it as a Solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
haha no, yours is by far the best way I would say, I was just too slow in creating my QVW

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure I understand the use of Aggr() function here?
Why can't we just use Rank(Sum([Sales Amount])) here? I mean as the dimension changes, the Rank() would automatically be based on the dimension we are seeing, why do we need to add Aggr() here? Sorry, if I missed something important detail here


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think I just assumed there would be more than one dimension in the table

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I guess my concern here is that what is the use of naked Aggr() function. We don't need to for sorting also, so just not sure why would need it even if we have multiple dimensions

- « Previous Replies
-
- 1
- 2
- Next Replies »