Calculated columns in pivot table

[#1]

Hello,

I need your help to define a calculated expression between columns depending columns values. What I want to do it's Age0/AgeDN, Age1/AgeDN...

I have a pivot table like that :

Two dimensions : Year (2010, 2011, 2012) and AGE (DN, 0, 1, 2, 3, 4...)

One expression : SUM(VAL)

YEAR	AGE	DN	0	1	2	3	4
2010		150 000	1	0	3	2	1
2011		20 000	2	10	2	1	1
2012		140 000	50	2	1	0	1
...

What I want it's to calculate an expression which give me this result

YEAR	AGE	DN	0	1	2	3	4
2010		150 000	1/150 000	0/150 000	3/150 000	...
2011		20 000	2/20 000	10/20 000	...
2012		140 000	50/140 000	2/140 000	...
...

How can I do that ?

Thank you for your help.

[Sokkorn]

Hi kiks51,

Can you share your app with sample data?

Regards,

Sokkorn

[kouroshkarimi · Accepted solution]

=if(age='DN',sum(VAL),sum(VAL) & '/' & first(sum({<age={'DN'}>}VAL),1,0))

Edit:

Based on your example file:

=if(TEV_AGE='DN',sum(TEV_VAL),sum(TEV_VAL) & '/' & first(sum({<TEV_AGE={'DN'}>}TEV_VAL),2,0))

[#4]

Thank you for your answer ! It works well. I've changed a little the expression because I wanted to evaluated the division. I didn't clearly express.

But now I have an other problem, it's how represent the same thing in a graph, how can I do that ?