After creating a Pivot Table from two tables, when I insert a column with data from Table 2, it does not show the number in the correct row. Instead, it repeats the value in every row down the column.
1.PNG
The row highlighted yellow should be the only row containing that number.
How can I fix this?
Bookmarks