I have a pivot table that sums transaction quantities of various items, per the column field values (being in Monthly lots or Weekly lots). These items are categorised, and categories are selectable in the slicer. The selections available in the slicer are A, B, C and X. For items in with Category "A", I'd like the Column field of the Pivot table to reflect "Weeks", on change (ie selecting from slicer) items B,C and X, i'd like the "sums" to be reflected in "Months". Any help greatly appreciated.