Expression as Dimension

[Anonymous]

Hello,

I have this expression:  count(distinct x)/Count(distinct TOTAL(x)).

And i would like to see have the results on dimension, however when i put this expression on dimension it gives me an error.

How can it be done?

Can you give me some pointers?

thank you

[Anonymous]

aggr(count(distinct x)/Count(distinct TOTAL(x)),yourdimension1[, ...])

It ist not possible to use aggregation functions in dynamic dimensions without aggr(), because "the aggregation area" ist not clearly defined else

[Anonymous]

Hello,

Thank you for your answer but i think that i have not explained well myself.

this expression count(distinct x)/Count(distinct TOTAL(x)).  gives me the  percentage of clients.

and i want to have that on dimension.

With your formula it doesn´t give me the data i need.

Thank you.

[Anil_Babu_Samineni]

Can yiu share the application which denomstrates the issue and share expected output please

[Anonymous]

aggr(nodistinct count(distinct x)/Count(distinct TOTAL(x)),x)

[Anonymous]

Hello,

with your formula it gives me this graph

[Anonymous]

could you post some data in excel format please?

[Anonymous]

Sure,

here you have

[Anonymous]

please check this

[Anonymous]

Hello,

Thank you for your help,

on expression i want the sum of sales accumulated. with that there is no problem.

on dimensions i would like the percentage of clients. so it goes from 0 to 100.

i do not know if it can be done.

thank you in advance