1. Create caluleted field Rank [AVG(Prize)]
2. Put Measure Names into Columns and Product ID into rows
3. Choose table from "Show me"
4. Edit Table calculations by rank pill and click table down
rank.twbx 14.4 KB
As I understand your question you want to know the rank of the product sales but don't to show the table in the viz?
Rank is a table calculation and it needs an underlying table that includes product ID - so the short answer is if Product ID is not in the underlying table for the view then you can't rank it - i.e. you can't "fix" a rank created in one view and use it another view
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Agreed with Jim, But you can Add Product ID to Details instead of view to get that.
Yes what I am aiming at is to get the rank where 1 indicates the largest price, 2 the second largest and so on.
I only need them to sum the products price with rank 1-10 , 11-20, 21-30 and so on.
is there no work-around?