Total column in pivot table

[surajap123]

Hi Experts,

I have pivot table with a dimension set to horizontal.

I want the TOTAL column by counting all the YES values for both dimensions. I did this by enabling show partial sum on the 2nd dimension, how how can i count(BranchNo) ?

Also, i want this TOTAL column to sit vertically beside the Location dimension. I am not sure how to achieve this.

Please help.

[CarlosAMonroy]

Hi Suraj,

Maybe you can try the following expression, it will sum the Y and N.

Yes:

if(Qty = 'Y',count( Qty))

No:

if(Qty = 'Y',count( Qty))

Hope that helps.

Carlos

[surajap123]

Hi Carlos,

Thanks for your reply.

I want only Y and N for the chart expressions.

I only want the count in the TOTAL column.

[krishnacbe]

Hi,

Please find the attached. hope that helps

[surajap123]

I think i didn't explain my requirement properly.

I don't want to change my existing expressions in the chart.

I only wan to have a new column that tells the total count of 'Y' values, beside the location column.

!

Thanks.

[vishsaggi]

something like this?

[sunny_talwar]

May be like this?

=Location & ' Count: ' & Aggr(Count(DISTINCT{<Qty = {'Y'}>}[Branch No]), Product, Location)