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.

[alexandros17]

Try with

Sum(amount)
/
Sum(TOTAL amount)

let me know

[swuehl]

=Sum(Amount) / Sum(TOTAL Amount)

You can format the number on number tab as percentage.

[sunny_talwar]

Alessandro Saccone solution should work, just need to make sure that Amount has a upper case A because QV is case sensitive.

Sum(Amount)
/
Sum(TOTAL Amount)

HTH

Best,

Sunny

[#5]

Hi,

i m trying this,

SUM({<MonthYear=, Date={"$(vCurrYr)"}>}Amount)/SUM(TOTAL{<MonthYear=, Date={"$(vCurrYr)"}>}Amount)

i m not getting correct values.

Pls help.

is the expression correct?

[#6]

Hi,

i m trying this,

SUM({<MonthYear=, Date={"$(vCurrYr)"}>}Amount)/SUM(TOTAL{<MonthYear=, Date={"$(vCurrYr)"}>}Amount)

i m not getting correct values.

Pls help.

is the expression correct?

[sunny_talwar]

I don't see any problem with your expression. Can you share may be a sample or a screenshot of what you getting?

[swuehl · Accepted solution]

Are you using more than one dimension, which you are not showing in above screenshot?

Then you may need to use a field list with your TOTAL qualifier, something like

=Sum(Amount) / Sum(TOTAL<OtherDimField> Amount)

[#9]

Hi,

i m getting this

but the value should be

pls help

[#10]

Hi Swuehl,

Tried this,

SUM({<MonthYear=, Date={"$(vCurrYr)"}>}Amount)/SUM(TOTAL<{<MonthYear=, Date={"$(vCurrYr)"}>}Amount>)

but getting NULL values.

is my expression wrong?

pls help