Subtotal of Percentage

[#1]

Hi I have a question,

i have a data like this:

the problem is on subtotal of percentage. I'm using partial sum on Brand dimension, and use sum(Percen) as expression. I don't want use sum(quantity2)/sum(quantity1) as expression in order to make data load faster, so i user sum(percen) directly.

But the total i expect is 6 (total of qty1) / 25 (total of qty2) = 0.24 ---------->24 %

Is it possible to make it without change the percen expression ?

Thanks

[#2]

I also attach my sample file here.

Thanks

[sunny_talwar]

Try this for your third expression may be

Sum(Aggr(Sum(QUANTITY1), Brand))/Sum(Aggr(Sum(QUANTITY2), Brand))

Sum(Aggr(Sum(QUANTITY2), Brand))/Sum(Aggr(Sum(QUANTITY1), Brand))

[#4]

HI

PFA

Thanks

Manju

[sunny_talwar]

Even this one works:

Sum(QUANTITY2)/Sum(QUANTITY2)

[#6]

Hi Sunny.

I've try your solution and it runs very well, but the problem is in load performance. The data load very slow. So i decide to directly use sum(percen) in order to not counting sum(quantity2)/sum(quantity1).

Is it possible to not change the percen expression ?

Thank you

[PrashantSangle]

Hi,

Try Column(1)/Column(2)

Regards