RE:Calculation of Sub-Total/Sum

priyav24 — Sun, 15 Sep 2013 08:20:44 GMT

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

Re: RE:Calculation of Sub-Total/Sum

priyav24 — Sun, 15 Sep 2013 10:02:31 GMT

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)