Issue with aggr function and dimension

[ramanarayan]

Hi Experts,

stalwar123‌

When i have only 1 dimension(FRCA_WeekYear as Dimension) and with below one expression

Count(Count(TOTAL DISTINCT Aggr(Customer,FRCA_WeekYear)))

i see below in my pivot.. Which is fine..

When i add one more dimension to this (Calc_FRCA_FR_Category), my number changes as per the addtnl dimension... which is fine... But i dont want my numbers to change i need that to be same as we see above.. Is it possible?

[sunny_talwar]

May be this?

=Count(TOTAL <FRCA_WeekYear> Customer)

Or this

=Aggr(NODISTINCT Count(Customer), FRCA_WeekYear)