New column

[soniasweety]

Hi All,

Olivier Robin

Anupam Mehta

Pooja Nagaraj

i want to create a new column in Pivot table

REQ: i need one extra column(Total)  the total column show always sum up the  COunt(New)+count(Old)

if user select any measure  for that measure also it should sum count(New)+Count(Old)

Result:

in above example  result column should be:

total

A: 2(New)+old(2)

B:1(New)+0(Old)

C:0(New)+1(Old)

[soniasweety]

type always it will disaply new and old   but total column  only    it should sum

[olivierrobin]

sorry, it was what i meant

if I click on New, you can see the chart shows only that column

[dx_anupam]

Hi Sony,

I think we can get it using calculated Dimension.

add formula =Aggr(Count(Id),Company) in calculated dimension.and label it as Total.

it might help you achieve desired output. only problem it will be start instead of end.

Regards,

Anupam  

[soniasweety]

No .  when user select any other dimension and mesure  it will not work

[soniasweety]

but if i select other measure it should sum the both

it shoudl show new and old

[dx_anupam]

Hi Sony,

I don't find any issue with it, can you please try and let me know result as its working perfectly fine at my end.

Regards,
Anupam

[olivierrobin]

the problem is that you try to create a new total column at another level.

Why don't you :

crate the column as sum()+count()+sum()

and add total at every level

so that your column id displayed at each detail level at at the total level ?

[soniasweety]

can you attch your app?

[olivierrobin]

1 - add an expression :

2 - add partial sum at "Type" level

[soniasweety]

its not giving me exact result