Home

Pivot table - summary

%3CLINGO-SUB%20id%3D%22lingo-sub-364586%22%20slang%3D%22en-US%22%3EPivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364586%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20summarise%20all%20the%20data%20on%20worksheet%20(Tracker)%20to%20show%20like%20worksheet%20(Report)%20and%20I%20have%20tried%20using%20pivot%20table%20but%20it%20is%20not%20showing%20the%20data%20that%20I%20would%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364586%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378015%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378015%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299087%22%20target%3D%22_blank%22%3E%40pegzz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fdesign-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EChange%20the%20layout%20into%20the%20tabular%20form.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378004%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F94034i44C0C6C94C3165BA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22screencap.png%22%20title%3D%22screencap.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20the%20pivot%20table%20settings%20to%20show%20the%20data%20in%20different%20columns%20like%20yours%3F%3C%2FP%3E%3CP%3EMine%20is%20like%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-366562%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-366562%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20seems%20to%20be%20one%20or%20more%20words%20missing%20in%20your%20text.%3C%2FP%3E%3CP%3EAnyway%2C%20just%20show%20the%20pivot%20table%20field%20list%20to%20see%20how%20the%20pivot%20table%20is%20set%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-365299%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365299%22%20slang%3D%22en-US%22%3EHi%20Thanks%20Detlef.%20In%20the%20pivot%20table%2C%20how%20can%20I%20items%20in%20the%20row%20into%20the%20columns%20like%20you%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364950%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364950%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20data%20is%20not%20suitable%20for%20a%20pivot%20table.%3C%2FP%3E%3CP%3EIt%20should%20look%20like%20the%20table%20in%20my%20uploaded%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
pegzz
New Contributor

I am trying to summarise all the data on worksheet (Tracker) to show like worksheet (Report) and I have tried using pivot table but it is not showing the data that I would like.

 

Please help.

5 Replies

Hello

 

Your data is not suitable for a pivot table.

It should look like the table in my uploaded file.

 

Hi Thanks Detlef. In the pivot table, how can I items in the row into the columns like you?

There seems to be one or more words missing in your text.

Anyway, just show the pivot table field list to see how the pivot table is set up.

 

screencap.png

 

@Detlef Lewin 

Thanks.

How can I get the pivot table settings to show the data in different columns like yours?

Mine is like this.

 

 

 

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies