Pivot table - summary

Question

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.&nbsp;Please help.

detlef_lewin · Answer

Hello&nbsp;Your data is not suitable for a pivot table.It should look like the table in my uploaded file.&nbsp;

pegzz · Answer

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

detlef_lewin · Answer

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.&nbsp;

pegzz · Answer

&nbsp;Detlef_Lewin&nbsp;Thanks.How can I get the pivot table settings to show the data in different columns like yours?Mine is like this.&nbsp;&nbsp;&nbsp;

detlef_lewin · Answer

pegzz&nbsp;&nbsp;Change the layout into the tabular form.

Forum Discussion

Pivot table - summary

5 Replies

Resources