So say I have a worksheet:
January-Purchases Jan-Services Jan-Maintenance Feb-Purchases Feb-Services Feb-Maintenance....
A1
A2
A3
I want a pivot table that can do:
January Feb March....
A1
A2
A3
Where the value of each cell would be a summation of purchases, services, and maintenance for each month.
Is this possible using pivot tables?
January-Purchases Jan-Services Jan-Maintenance Feb-Purchases Feb-Services Feb-Maintenance....
A1
A2
A3
I want a pivot table that can do:
January Feb March....
A1
A2
A3
Where the value of each cell would be a summation of purchases, services, and maintenance for each month.
Is this possible using pivot tables?