Home

Pivot tables - multiple selections for same fields

%3CLINGO-SUB%20id%3D%22lingo-sub-779301%22%20slang%3D%22en-US%22%3EPivot%20tables%20-%20multiple%20selections%20for%20same%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779301%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20have%20a%20monthly%20sales%20report%20that%20shows%20YTD%202019%20and%20Totals%20for%202018%2F2017%2F2016%20by%20default%3B%20i.e.%20months%201%20to%2012%20are%20all%20selected.%20I'd%20like%20to%20insert%20another%20column%20that%20shows%20YTD%202018%20but%20keep%20the%20Totals%20in%20place.%3C%2FP%3E%3CP%3EObviously%20if%20you%20change%20the%20months%20selected%20then%20all%20of%20the%20previous%20years%20revert%20to%20showing%20YTD.%3C%2FP%3E%3CP%3ECould%20anyone%20help%20me%20in%20how%20to%20do%20this%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPivot%20tables%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
NeilS355
Occasional Visitor

Hi

I have a monthly sales report that shows YTD 2019 and Totals for 2018/2017/2016 by default; i.e. months 1 to 12 are all selected. I'd like to insert another column that shows YTD 2018 but keep the Totals in place.

Obviously if you change the months selected then all of the previous years revert to showing YTD.

Could anyone help me in how to do this please?

Related Conversations
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Filter complex table to simple table
Sam2009 in Excel on
1 Replies