sum total column

[Anonymous]

hi,

can i do in pivot  sum total for column ? sum(total(coulm(14)))

i meen i had columns that show the result for diffrents columns ( i can't make sum total for that - it's to comliceted )

thanks'

yarin.

[brindlogcool]

You can do it using the set Analysis. ---sum( {1} Total Sales ). Check the reference manual/Help option for more option,

[MK_QSL]

Go to the Presentation Tab and Select Partial Sum.

Hope this will help.

If your problem still not solved, please upload you sample file.

[#4]

You can use already created expressions in other expressions you create.

Like suppose if you have:

column14 = aggr(sum(TestData),Category)

Then

Column15 can use column 14 like

=aggr(column14,Product)

Is this what you expect?

Hope it was helpful or let me know if any other questions you have

[israrkhan]

i think you cant do it,

because Column(14), mean the display value. total will not affect it.

but you can copy the expression from column 14 and add total on it, so it will work..

[Anonymous]

Hi Yarin,

You and get total for a column with below expressions
=sum(Column14)

=sum({1} Column14)