save pivot table sum in variable

Thu, 09 Aug 2012 11:01:10 GMT

Hi,

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

regards,

Re: save pivot table sum in variable

MayilVahanan — Thu, 09 Aug 2012 21:37:10 GMT

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)