Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-1954060%22%20slang%3D%22en-US%22%3EPivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1954060%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20csv%20of%20employees%20and%20daily%20hours%20worked.%20I%20need%20to%20provide%20weekly%20subtotals%20for%20each%20employee%20over%20a%206-month%20period.%3C%2FP%3E%3CP%3EHelp%20please.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1954060%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1954382%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1954382%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%2F890332%22%20target%3D%22_blank%22%3E%40EllenCassel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20please%20upload%20the%20CSV%20file%2C%20so%20we%20can%20have%20a%20look.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a csv of employees and daily hours worked. I need to provide weekly subtotals for each employee over a 6-month period.

Help please.

1 Reply

Hi @EllenCassel 

Would please upload the CSV file, so we can have a look.