how to calculate a new column in pivot table

[Tarig]

Hello 

I have this Pivot table and I i'm try to add a new calculated column (Total) which is the sum of (People w Sale + People W/T Sale+ Not Declared). How I can do that. Thanks alot

 

[anthonyj]

Hi Tarig,

Pivot tables have the option to add Totals to either the columns or the rows however this is a calculation over all values in your columns. Looking at the documentation I couldn't find a way of adding a total that doesn't include all values. I'd be interested in hearing if anyone else can come up with answer to this.

In the mean time an option you could consider is a straight table with multiple measures using set analysis to break up each of the columns to their relevant Category. This way your Total column could be a set analysis where your Category is equal to {'People w Sale', 'People W/T Sale', 'Not Declared'}.

Regards

Anthony

[BtBread]

How about a new measure with '=Column(1)+Column(2)+Column(3)'

[Tarig]

Thank you BtBread but not an option.