Ania on 04 Jan 2017 17:04:48
I would like to apply the topN function to the full level of the hierarchy. i.e. top 5 store sales, top 5 department sales, top 5 product sales, where the hierarchy consists of products, department and stores.
Currently you need to place a topN on each level causing the highest level to show only one value and not 5. In addition when drilling to the top all the filters disappear.
I have searched all over for this, so if this does exist, please advice.
- Comments (1)
Comments (1)
RE: TopN applied to all levels of Hierarchy
I'm also facing the same issue.. Microsoft team please have a look and share the results