Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Have a look at the attched document.
Regards,
Kaushik Solanki
try this
Chart Properties> Expressions> Totals>
Rangesum(fieldName,1,noofrows())
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
@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.
first write your actual fieldname u want
and then
type this in expression
if( dimensionality()=0,
Rangesum(fieldName,1,noofrows()),sum(fieldName))
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...
ok thanks for explanations...
I tried
if( dimensionality()=0,
Rangesum(fieldName,1,noofrows()),sum(fieldName))
but...i've the same result with this expression
Hi,
Can you upload the sample file.
Regards,
Kaushik Solanki
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
i've tried this solution but it doesn't work! ^^ thanks...