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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies