values/Total in pivot table

[#1]

Hi Experts,

i have the following tables,

BRANCH:

LOAD DISTINCT

  BRNO,

  SALESREPORTS,

  Year(Date) as AGE

FROM [BRANCH.qvd](qvd);

Sales:

LOAD BRNO,

     DATE,

    Amount

FROM

[SALES.qvd]

(qvd);

from this, i have produced the following pivot table,

Now, i need to add another expression as Share.

formula is Share = Amount/Total (i.e., for age 2010, the share is 25896/185429 = 13.96%)

How can i do this in a pivot table.

plsss help.

[swuehl]

yes, I suggested a field list to the TOTAL qualifier, not a set expression.

I assume that your issue is caused by the way your two tables are linked,

Your dimension is age, but you are linking the tables by Branch. Hence depending on the relation of age to Branch, I could think of conditions where your Sales values won't sum up to 100%.

Could you upload small sample QVW to check if this is the case?

[sunny_talwar]

You can try this:

Sum(Amount)/Sum(Aggr(Sum(Value), AGE))

[#4]

ok

found the issue.

missed a parameter on expression.

now fixed it.

got the values.

thanku all