Need partial sum data in other table to be displayed

[#1]

Hi,

I need to display the partial sum data in different table. How do I do this?

[hic]

You cannot easily fetch a partial sum from a chart and use that somewhere else. Instead you should write the proper expression where you need the partial sum.

To make it partial, use Set Analysis. For example, if you want the partial sum of Sales for United Kingdom, then write

     Sum( {$<Country={'United Kingdom'}>} Sales )

HIC

[preminqlik]

in which table....u can use aggr function and store in variable ...use in other table

[#4]

Thank you everyone. I edited the script and it worked