I have the category and product hierarchy, a classification is applied to this hierarchy.
For example, rank 5 should show me 5 categories and each category should show me 5 products.
There is some way to calculate the ranking in this way without the product dimension being in view.
?
4 answers
Okay so here's what I did:
- Create a new calculated field, Index Filter = INDEX() <= [top]
- Add it as a filter to your view and select True
- Remove the [Ranking] filter
- Right click the [Index Filter] filter, hover over Compute Using..., then select Pane Down
- Now add [Subcategoria] as a filter to you view and (a) under the General tab, select Use all values, then (b) under the Top tab, select By field, then Top [top] (from the 2nd dropdown) by the sum of [Ganancia]
- Add your [Subcategoria] filter to context (right click the filter and select Add to Context)
I've attached your workbook with these steps followed for reference.
I hope this helps!
Kelsie
