[Excel] How do you merge pivots?

[Typhoon]

Hi,

Our accounts guy at work is doing daily analysis on reasons we have had to issue refunds.

He only started this Monday last week and has done a pivot table every day, the reasons why the refund was issued (generic set through Magento)

His boss has now asked him he wants a full count for that week.

Is there any way to merge all the pivots in to one 'master'? He is currently doing =SUM(A1+A2) etc, on all the cells that are "Not in Stock".

I have attached a screenshot. Obviously the blurred bit is just the amounts.

Cheers

 

[Budgie]

Paste values and then do another pivot of all of those values would work, but not sure it's much quicker than summing, lol.

 

[Typhoon]

Paste values and then do another pivot of all of those values would work, but not sure it's much quicker than summing, lol.

Ah - I thought this would be the case, just wanted to double check if anyone knew of a quicker way! Cheers mate

 

[Tim.]

Is all the source data in the same location? And does it have a day/date column? If not, can it be easily pasted into one table?

Otherwise =SUMIF is another option.