Table expression using Set Analysis

[linoyel]

Hey all,

I need help in writing the table expression.

Lets say, I have different products and my first expression is sum(sales).

I need second expression that will calculate sum(sales) out of TOTAL sum(sales) and show the result in percents...

[tresesco · Accepted solution]

Try like:

=Sum(Sales)/Sum(TOTAL Sales)

And check/tick 'Show in percent (%)' in the number tab.

[senpradip007]

As per my understanding you are calculating proportion.

try with: Sum(Sales) / Sum(TOTAL Sales).

[linoyel]

Than't right!!!

Thank you so much

[#5]

Thank You for you help..