Change Pivot Value Field either sum of QTY/Val by using Macro

[sureshpunna]

Hi,

how change pivot table value field either QTY and Value.

if click on QTY command button pivot table values field should come sum of QTY and

if click on Value Command button pivot table values field should come sum of Value.

Please help.

Pivot_1.xlsx

Suresh

[Richard Buttrey]

Hi,

You'll need to upload the workbook so that we can see the request in context.

[sureshpunna]

Hi Richard, I have attached file to previous thread

[Richard Buttrey]

Hi,

See attached.

Why though do you need a button. Why not just have the Qty & Value showing all the time?