I have a requirement on stock cube where in I need to show the maximum stock quantity for a particular day in a month.
I can achieve this by using exception aggregation on the key figure. But the issue is when I drill down to see the calendar day, all the days in the month are displayed. I just want the display calendar day where the quantity was high. Any inputs are really appreciated.