Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table contains id, department, date, amount
In pivot table, My dim is department and expression sum(amount)
and added count(id) as my second dimension
am trying to show in my calculated dimension,Count(id) of Max(Month) for each department.
how do we achieve this??
PFB for your reference!!
Please suggest.!!
For the sample you attached
May be this
=Aggr(If(Month = Max(TOTAL <dept> Month), Count(id)), dept, Month)
For the sample you attached
Thanks Sunny !!!!