SOLVED

Pivot Table deleting selective data

%3CLINGO-SUB%20id%3D%22lingo-sub-1527945%22%20slang%3D%22en-US%22%3EPivot%20Table%20deleting%20selective%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527945%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20never%20attempted%20to%20use%20Pivot%20Tables%20before%20this%2C%20so%20maybe%20what%20I%20am%20trying%20is%20out%20of%20the%20realm%20of%20what%20I%20should%20be%20doing%20but%20here%20is%20the%20idea%3A%20I%20am%20attempting%20to%20have%20a%20different%20Pivot%20Table%20for%20each%20month%2C%20each%20pulling%20from%20the%20same%20data%20source.%20This%20is%20to%20keep%20track%20of%20installs%20on%20a%20monthly%20basis.%20I%20made%20a%20practice%20sheet%20with%20tab%20of%20fake%20data%20and%20a%20separate%20tab%20for%20the%20Pivot%20Tables.%20Once%20I%20first%20set%20the%20filter%20on%20each%20table%20using%20the%20%22between%22%20filter%20and%20using%206%2F1%2F2020%20to%206%2F30%2F2020%20for%20the%20label%20range%2C%20it%20separates%20the%20data%20perfect%20the%20way%20I%20want.%20I%20duplicated%20the%20table%20and%20repeated%20the%20process%20changing%20the%20range%20for%20July%2C%20June%2C%20and%20September.%20Everything%20is%20looking%20good%20at%20this%20point%20so%20I%20save%20it%20and%20reopen%20the%20whole%20sheet.%20I%20can%20visually%20see%20June%20and%20September%20lose%20the%20data%20while%20July%20and%20August%20are%20unaffected.%20I%20have%20tried%20changing%20the%20formatting%20of%20my%20data%20to%20a%20table%2C%20this%20didn't%20help.%20I%20took%20off%20auto-refresh%20data%20upon%20sheet%20opening%20and%20that%20didn't%20help.%20Anyone%20have%20some%20ideas%20for%20me%20to%20try%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1527945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528003%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20deleting%20selective%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528003%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731315%22%20target%3D%22_blank%22%3E%40AnthonyJSHE%3C%2FA%3E%26nbsp%3B%2C%20your%20end%20date%20is%20the%2031st%20for%20June%20and%20September.%20They%20both%20have%20only%2030%20days.%20Try%20changing%20the%20last%20date%20in%20the%20filter%20to%206%2F30%2F2020%20and%209%2F30%2F2020.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528013%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20deleting%20selective%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528013%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%2C%20I%20think%20that%20did%20the%20trick.%20Dang%20all%20the%20messing%20around%20I%20tried%20and%20it%20was%20right%20in%20front%20of%20me.%20Thank%20you%20for%20noticing%20that!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528016%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20deleting%20selective%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528016%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731315%22%20target%3D%22_blank%22%3E%40AnthonyJSHE%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have never attempted to use Pivot Tables before this, so maybe what I am trying is out of the realm of what I should be doing but here is the idea: I am attempting to have a different Pivot Table for each month, each pulling from the same data source. This is to keep track of installs on a monthly basis. I made a practice sheet with tab of fake data and a separate tab for the Pivot Tables. Once I first set the filter on each table using the "between" filter and using 6/1/2020 to 6/30/2020 for the label range, it separates the data perfect the way I want. I duplicated the table and repeated the process changing the range for July, June, and September. Everything is looking good at this point so I save it and reopen the whole sheet. I can visually see June and September lose the data while July and August are unaffected. I have tried changing the formatting of my data to a table, this didn't help. I took off auto-refresh data upon sheet opening and that didn't help. Anyone have some ideas for me to try?

3 Replies
best response confirmed by AnthonyJSHE (New Contributor)
Solution

@AnthonyJSHE , your end date is the 31st for June and September. They both have only 30 days. Try changing the last date in the filter to 6/30/2020 and 9/30/2020.

@TheAntony , I think that did the trick. Dang all the messing around I tried and it was right in front of me. Thank you for noticing that!

@AnthonyJSHE , you are welcome.