subtotal and total for pivot table

[#1]

Hello!

I would like to sum all the values in a column in a pivot table.

It's possible for simple tables using the Chart Properties> Expressions> Totals> sum of lines but for pivot table i don't know how to do...
I've tried using the Chart Properties> Presentation> SubT otals, but the results are false...

I put an Excel file attachment. There are comments on some cells.

Thanks a lot for your help

[SunilChauhan]

try this

Chart Properties> Expressions> Totals>

Rangesum(fieldName,1,noofrows())

[kaushiknsolanki]

HI,

   You can try below expression.

    if(sum(ACTIF_NET_GLOBAL)=0,sum(LAST_ACTIF_NET_GLOBAL), sum(ACTIF_NET_GLOBAL))

   In your pivot chart.

Regards,

Kaushik Solanki

[#4]

@Sunil Chauhan

i would try but i don't understand...where can i put this expression?

When i use a pivot table, i have only the choice between : "no total", "total expression", or "sum of lines" in the box TOTALS.

[SunilChauhan]

first write your actual fieldname u want

and then

type this in expression

if( dimensionality()=0,

Rangesum(fieldName,1,noofrows()),sum(fieldName))

[#6]

hi,

thanks for yours answers..

i tried : if(sum(ACTIF_NET_GLOBAL)=0,sum(LAST_ACTIF_NET_GLOBAL), sum(ACTIF_NET_GLOBAL))

but i've the same result...

[#7]

ok thanks for explanations...

I tried

if( dimensionality()=0,

Rangesum(fieldName,1,noofrows()),sum(fieldName))

but...i've the same result with this expression

[kaushiknsolanki]

Hi,

   Can you upload the sample file.

Regards,

Kaushik Solanki

[SunilChauhan]

first convert pivot into straight

then go to expression and check sum of rows

then again cconvert into pivot table

go to presentation-> show partial sum-> subtotal on top

hope you require this

[#10]

i've tried this solution but it doesn't work! ^^  thanks...