How to add a calculated column in a pivot table

[#1]

Hi,

the pivot table in the image has as a column filed 'Divisa' which has two values '<Entity Curr Total>' and 'Mloc', but the expressions in the pivot table is just one 'sum(Importe)'.

How could I to add a new column with the 'sum(Importe)' difference between the values of 'Divisa' called '<Entity Curr Total>' and 'Mloc'?

Thanks

[vikasmahajan]

You can column(2)-Column(1)  to find out diffrence between values.

Hope this helps.

Regards

Vikas

[giakoum]

Divisa is a dimension? If yes, you need set analysis, something like :

sum({$<[Divisa]={"Entity Curr Total">} [Importe]) -

sum({$<[Divisa]={"Mloc">} [Importe])

[#4]

I think it is almost the solution but , do you know why it repeats and why it does with the addition instead of doing with the difference?

[#5]

I think it is almost the solution but , do you know why it repeats and why it does with the addition instead of doing with the difference?

[giakoum]

sum(total <Alias, Cuenta> {$<[Divisa]={"Entity Curr Total">} [Importe]) -

sum(total <Alias, Cuenta> {$<[Divisa]={"Mloc">} [Importe])

or similar depending on Dimensions

If this does not work you need to Aggr...

without some sample it is difficult to tell...

[#7]

...this is getting complicated for me... I have attached the file

[giakoum]

I prepared a small example, unfortunately I do not have the time to go through your application. Sorry about that!

[#9]

Hi can't understand why your neat example do not work with my dimensions but I appreciate your piece of knowledge a lot.

Thank you very much.

[#10]

Hi,

i'm facing exactly the same problem. Did you find any way to solve yours ?

Regards

Chung Fabien