Transfer specifc PivotTable data to a new sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3298983%22%20slang%3D%22en-US%22%3ETransfer%20specifc%20PivotTable%20data%20to%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3298983%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20PivotTable%20of%20stores%20of%20rent%20payments%20by%20month%20conditionally%20formatted%20to%20highlight%20a%20month%20where%20the%20rent%20was%200.%26nbsp%3B%20I%20want%20to%20pull%20all%20the%20stores%20where%20rent%20was%20missed%20in%20the%20batch%20payment%20for%20that%20month%20to%20a%20new%20sheet.%20For%20example%2C%20my%20PivotTable%20looks%20like%20the%20below.%20How%20do%20I%20pull%20store%20%235%20with%20the%20store%20%23%20and%20months%2C%20whenever%20that%20month%2C%200%20was%20processed%3F%20The%20goal%20is%20to%20do%20that%20for%20all%201500%20stores%20so%20I%20can%20see%20more%20quickly%20when%20a%20month%20was%20missed.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22396%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2276%22%3ERow%20Labels%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EJan%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EFeb%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EMar%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EApr%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EMay%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E100.00%3C%2FTD%3E%3CTD%3E100.00%3C%2FTD%3E%3CTD%3E100.00%3C%2FTD%3E%3CTD%3E100.00%3C%2FTD%3E%3CTD%3E100.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E200.00%3C%2FTD%3E%3CTD%3E200.00%3C%2FTD%3E%3CTD%3E200.00%3C%2FTD%3E%3CTD%3E200.00%3C%2FTD%3E%3CTD%3E200.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E300.00%3C%2FTD%3E%3CTD%3E300.00%3C%2FTD%3E%3CTD%3E300.00%3C%2FTD%3E%3CTD%3E300.00%3C%2FTD%3E%3CTD%3E300.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E400.00%3C%2FTD%3E%3CTD%3E400.00%3C%2FTD%3E%3CTD%3E400.00%3C%2FTD%3E%3CTD%3E400.00%3C%2FTD%3E%3CTD%3E400.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E500.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3298983%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
Visitor

I have a PivotTable of stores of rent payments by month conditionally formatted to highlight a month where the rent was 0.  I want to pull all the stores where rent was missed in the batch payment for that month to a new sheet. For example, my PivotTable looks like the below. How do I pull store #5 with the store # and months, whenever that month, 0 was processed? The goal is to do that for all 1500 stores so I can see more quickly when a month was missed. 

 

 

Row LabelsJanFebMarAprMay
1100.00100.00100.00100.00100.00
2200.00200.00200.00200.00200.00
3300.00300.00300.00300.00300.00
4400.00400.00400.00400.00400.00
5500.000000
      
0 Replies