Generate expression for calculated values

[agni_gold]

Hi All ,

I have two table

Account	Value
A	10
B	20

Account

A

B

C

Now I have loaded these tables , And Created one pivot table ,

Here value of C=A+B

For this i have written expression ,

if(Account='C',Sum({<Account={'A'}>}Value)+Sum({<Account={'B'}>}Value),Sum(Value))

But it is not showing value for C

Please help , attaching my sample application

[maxgro · Accepted solution]

maybe with a total

if(Account='C',Sum({<Account={'A'}>}total Value)+Sum({<Account={'B'}>}total Value),Sum(Value))

[petter]

You could change the expression to this:

if(Account='C',Sum(TOTAL {<Account={'A'}>} Value) + Sum(TOTAL {<Account={'B'}>} Value),Sum(Value))

[agni_gold]

Here is my situation ,

In attached excel , i have data ,

and attached qvw has my situation ,

Calculated account C , is not distributing as per my cyclic group.

please help

[agni_gold]

Please see my below response and help

[agni_gold]

Please see my below response and help