Forum Discussion
Using hierarchy for Date filters
Hi,
I am trying to use Date Heirarchy and when using, when I drill down and if data has more than a years details, numbers from the years are getting mixed given the total. eg., if Jan 2017 value is 15 and Jan 2018 value is 10 i am getting only 1 column with value 25 which is wrong.
I am using Matrix visual and filtered to get data of Q1 for both 2016 and 2017.
I am looking to get something like
| 2016 | 2017 | |||||
| January | February | March | January | February | March | |
| ABC | 10 | 12 | 13 | 22 | 12 | 53 |
| DEF | 1 | 2 | 3 | 4 | 5 | 6 |
| GHI | 3 | 23 | 23 | 6 | 5 | 3 |
But I am getting
| Janury | February | March | |
| ABC | 32 | 24 | 66 |
| DEF | 5 | 7 | 9 |
| GHI | 9 | 28 | 26 |
It seemed like basic requirement but I couldnt find where I am missing.
Any help is much appreciated.
Thanks
S
you should use 'fork' drilldown rather than 'double arrows' one
Hi sn123,
You should click "Expand all down one level in the hierarchy" as below:
Regards,
Jimmy Tao
3 Replies
- StachuCommunity Champion
you should use 'fork' drilldown rather than 'double arrows' one
- v-yuta-msftCommunity Support
Hi sn123,
You should click "Expand all down one level in the hierarchy" as below:
Regards,
Jimmy Tao
- sn123Frequent Visitor
Thank you Jimmy Tao.