Forum Discussion
Interactive drill-down
Hi v-qiuyu-msft
Thanks for this. Just a recheck? 10/12/2017 you meant dd/mm or mm/dd? As I already received questions from my business users re this functionality.
Furthermore, I think it can be bucketed under the same question. Let us say this is re 'interactivce inter-filtering across numerous sections'
Situation:
I currently present my summarised P&L accounts. The user is able to isolate their month (1) which in turn filters out the product and location dimensions. So far so good.
However, what I want to do together:
1. To be able to select my month (all good).
2. Then select my biggest variance contribut in my now-filtered product matrix WITHOUT LOSING my previous month selection (my primary month selection is lost here if I click on anything in my product matrix).
3. This, subsequently, should filter out my location matrix futher for that particular month and that particular product.
I understand that it can get ambigous - what filters out what in which case, but I see that is a lack of functionality. This would IMMEDIATELY cut down on the time spent doing our var analyses.
Thanks
Ged