CALCULATED FIELD IN PIVOT

[Anonymous]

Hi,

I am fairly new to Qlikview and am looking for your help in fixing a challenge with pivot table. I have created a pivot table in one of my reports and now I need to create a calculated field.  Sample -

COUNTRY	PROMOTERS	DETRACTORS	PASSIVES
CHINA	2002	2020	2038
AUSTRALIA	2036	2054	2072
UK	2070	2088	2106
USA	2104	2122	2140

Where Promoter, Detractors & Passives are values of one of the fields. What I essentially need is to create a new calculated column that should be  (Promoter - Detractors) / Sum(Promoter, Detractors & Passives).

Any help will be really appreciated.

Thanks,

Ritesh

[Anonymous]

Hello Sunny,

This doesn't seem to be working for me. Please refer to the attached file.

I am unable to use the file you have shared as I am using personal edition. Please help !

Thanks,

Ritesh

[sunny_talwar]

Two things

1) Use just one expression here

2) Enable partial sub totals for your 2nd dimension

After those 2 changes, I get this

[varunamin]

Hi Sunny, Your post was very helpful. Using that I was able to create one calculated column in pivot table but how can I show 2 calculated columns in pivot table. Please let me know if that's possible. Thanks!