Trying to set up pivot table in Excel Office 365. I select insert Pivot Table. The pivot table page shows up but without the Pivot table fields showing up on the right. I get those to show up by right clicking in the Pivot Table 1 panel on the left. I then pick two columns as rows and this works. I select another column for Values. That column shows up on the pivot table but does not show up in the Pivot Table Fields under Values. I then select another column to include as values. This one does not show up on the Pivot Table Fields and the column shows up to the left of the first value column on the pivot table.
Solved by A. W. in 28 mins