Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try this:
If(GetSelectedCount(ddate_year) = 0, RangeSum(Above(Sum(amount), 0, NoOfRows(TOTAL))),
If(GetSelectedCount(ddate_month) = 0, Aggr(RangeSum(Above(TOTAL Sum({<ddate_day, ddate_month, ddate_year, MonthYear>}amount), 0, NoOfRows(TOTAL))), MonthYear),
Aggr(RangeSum(Above(TOTAL Sum({<ddate_day, ddate_month, ddate_year, MonthYear>}amount), 0, NoOfRows(TOTAL))), MonthYear, ddate_day)))
You mentioned something is going wrong, but would you be able to elaborate what the issue is? I am not entirely sure I know what is wrong?
in first picture that i attached you can see the amount in 11 month but when i drill to day in this month the last amount is other thing (pic2)