aggr

[satishqlik]

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.!!

[sunny_talwar]

May be this

=Aggr(If(Month = Max(TOTAL <dept> Month), Count(id)), dept, Month)

[sunny_talwar · Accepted solution]

For the sample you attached

[satishqlik]

Thanks Sunny !!!!