Pivot table of multiple columns in PowerQuery

Hi All,

I am trying to transform multiple columns of my data set so I can express them all in one dashboard.

For the purpose of finding a solution I have simplified what I am trying to do into an example of 'Person' from a certain 'Country' and the 'date' that they bought either a 'Red', 'Green' or 'Yellow' top on.

What I am trying to achieve is one dashboard that end users can then filter by top colour to see total amounts of top colours purchased in certain dates, or countries.

Currently my data is in this format:

I am thinking it would be best to use a PivotTable to get it in the form of:

When I try to do this, it comes up with "Expression.Error: We cannot apply a Pivot operation over a table that contains columns with nested data. Please remove these columns first"

Would anyone please be able to help me with a way to get my data in the right form and visualised how I am visioning?

Thanks so much, would appreciate any help!