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?
Sorry. I did not phrase it correctly.
When adding 2nd dimension, the numbers change which i want to prevent from happening. Anyway i can acheive this
Would you like to share sample?
Do you mean that you want to duplicate the original table four times? One for each Calc_FRCA_FR_Category?
If so, use a dummy as your dimension: