Pivot can't show number but date

%3CLINGO-SUB%20id%3D%22lingo-sub-2012195%22%20slang%3D%22en-US%22%3EPivot%20can't%20show%20number%20but%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2012195%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20team%2C%20can%20you%20pls%20help%20on%20this%2C%20I%20made%20pivot%20from%20existing%20sheet%2C%20select%20filter%20%22Week1%22%20but%20see%20number%20in%20date%20format%2C%20not%20real%20number.%3C%2FP%3E%3CP%3EThanks%2C%26nbsp%3B%3C%2FP%3E%3CP%3EChinh%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2012195%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2013863%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20can't%20show%20number%20but%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2013863%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F910253%22%20target%3D%22_blank%22%3E%40Chinh2255%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20attach%20the%20sample%20data%20with%20few%20records%20as%20need%20to%20understand%20how%20you%20have%20maintained%20your%20data%20in%20the%20source.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Faraz%20Shaikh%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi team, can you pls help on this, I made pivot from existing sheet, select filter "Week1" but see number in date format, not real number.

Thanks, 

Chinh

1 Reply

Hi @Chinh2255 ,

 

Can you please attach the sample data with few records as need to understand how you have maintained your data in the source. 

 

Regards, Faraz Shaikh