Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QS expert,
I am using the pivot table to show the value.
I have two layers of rows:
The first one is the following expression, with the label "Group"
=ValueList('Overall','Indirect HKG','Indirect Region','Cabin Crew','Cockpit Crew','Direct (Others)')
The second one is, with label "YearMonth"
=
Aggr(only({<[date_month]={">=$(=AddMonths(vRollingDate,-11))<=$(=MonthEnd(vRollingDate))"}>}
[date_month.autoCalendar.YearMonth]),[date_month.autoCalendar.YearMonth])
For the Value I put the following, labeled as "Turnover"
I've checked the expressions but didn't find error. I wonder why only the first row shows the value?
@BoXiangWang try with aggr including YearMonth dimension
Hi Kushal,
Thanks for your reply. I did it but still the table showed 0 apart from the first row.
I tried to debug it and tested the following expression, which gave me the outcomes without aggregating and then summing. The result is not what I want. I don't get it why the first row(Overall) could fetch the data but others couldn't.