Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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?
May be this?
=Count(TOTAL <FRCA_WeekYear> Customer)
Or this
=Aggr(NODISTINCT Count(Customer), FRCA_WeekYear)