RE:Calculation of Sub-Total/Sum

[priyav24]

Hello Everybody ,

                                   I have an requirement where i need to calculate sub-total divided by Sum..

For example

we have two levels say Division,Brand and Amount..i need to calculate total amount (Division)/amount(brand)..

right now its taking the overall total instead of division-wise total.

Note:I have also attached qvw for reference

Thanks in Advance,

Priya

[priyav24 · Accepted solution]

Finally , got the solution for the calculating the sub-totals / sum ..

Its basically , we need to specify the dimension field for which sub totals to be calculated in angular brackets..

= sum(total <Dimension-Field> Fact-Name)/ Sum(Fact-Name)