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?

[shiveshsingh]

hi

I couldn't get this line, What do you mean by this?

But i dont want my numbers to change i need that to be same as we see above

[ramanarayan]

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

Thanks

[sunny_talwar]

May be this

Aggr(NODISTINCT Count(DISTINCT Customer), Calc_FRCA_FR_Category)

[ramanarayan]

Sorry Sunny. No luck

[Anil_Babu_Samineni]

Would you like to share sample?

[Janneke]

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:

=ValueList('High','Medium','Low','Never Loggedin')

[sunny_talwar]

Would you be able to share a sample?

[ramanarayan]

Hi Sunny/Anil,

Attached is the qvw and excel with sample data.

Thanks

[ramanarayan]

added above. Thanks Anil