Using the maximum of an expression as base to calculate percentage on another expression.

[#1]

Hi.

I have a chart (Straight Table) that calculates "sales" as an expression over "month" as a dimension.

I then need to add another expression within the same chart that calculates the percentage of other months against the maximum sale of the first expression ("sales").

In other words if the max month was november and sales were 562, the percentage of sales october(if products sold were 300) would be against 562 and would therefore be (300/562) * 100.

Thanking you in advance

regards

Gopolang

[tresesco]

Try something like this expression : Sale/ max( Total Sale)/ 100.... use this with Sum() function properly if needed.

Regards, tresesco