Table expression with Set Analysis

[linoyel]

Hey all,

I need help in writing the table expression.

I have 1 dimension (Products) and my first expression counts people who were interested in that product: count(customers).

I need second expression that will calculate count(customers) for a specific product out of total count(customers) and show the result in percents...

For example, 5 people were interested in apples and 3 people were interested in oranges.

Total is 8 people.

So for the apples row, I need an expression that will do this: 5/8 *100%

And for the oranges row it will be: 3/8 *100%

Of course, all other "current selections" are supposed to stay the same.

[#2]

try this:

count(customers) / count({<Products = >}customers)

if you have any other dimensions then Products you also have to use them in set analysis.

regards,

MT

[eduardo_sommer · Accepted solution]

It's count(customers)/count(TOTAL customers)

Eduardo

[Anonymous]

Try out:

(count(customers)/count(total customers))*100

Regards

Nitin

[tresesco]

I guess the solution was suggested in other thread here holds good. Did you you try that? Otherwise, try to post your sample qvw.

[linoyel]

Thank you

This worked

[linoyel]

Yes, thank you!

I didn't think it was THAT simple!

Already checked your answer as a correct one in a first thread