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]

only  need in result is

always   sum(only net  value)  and should as total  .... no other should not be summed in total column

[soniasweety]

its should  be dimension level  

[olivierrobin]

I know

but it seems impossible to show/hide a columns on a crosstbale based on dimensionality/secondarydimensionality

[olivierrobin]

and it's also impossible to have two differents levels  of totals in that same graph