save pivot table sum in variable

[#1]

Hi,

Can I save the sums of a pivot table in a variable?

regards,

MT

[MayilVahanan]

Hi

     I can't get you clearly, but you can use like this,

     For example,

     vPivotValue = sum(Sales) , suppose you using sum(Sales) in pivot table.If don't want to change means,you can use like this sum({1}Sales)