extract specific pivot table data to a new sheet
Please help on this daily boring task , if it can be done by Macro or Formula.
From ProductName_general field I select Auto
From Productname field i select multiple items (Auto,Auto Balloon,Auto Stepup),
From the Channel fieldDIB,DIBLDY,INB selected.
then from Zone field i select
Zone A
after that what is required is to copy the resulting two rows Total Count , Total amount to new Sheet.
then Zone B
copy the resulting two rows Total Count , Total amount to the same new Sheet. below the two previous rows.
.
.
.
the last Zone G. copy the resulting two rows Total Count , Total amount to the same new Sheet. below the previous rows.
please please assist.
thanks in advance.
Reda.
|