Forum Discussion
Korekar27
2 years agoHelper I
DAX
I am facing one difficult scenario. In the below image If I click on MTD it should show me MTD sales, and when I click Quantity it should show me MTD Quantity, If I click on City it should city wise Quantity and it should be shown in the option I select in Time series. Similarly if I choose Top or bottom it should show me the result by taking in consideration the above filters whatever filter i choose. Also I should be able to choose between Top 5,10,15 Bottom,5,10,15
i am providing sample datasethttps://docs.google.com/spreadsheets/d/1A9r0UvvMjZIA3fZvqViuBXNVNz9bR9Cw/edit?usp=drive_link&ouid=117941987829098447596&rtpof=true&sd=true