I have a problem to create a pivot chart using my data..
Can u suggest to how to translate these data to pivot chart eg: - Quantity vs Item category
- Quantity vs year
- Price vs year
Sorry i cant show pricing column though
Hi John,
The problem is caused by the incorrect data layout for a PivotTable. PivotTables require tabular data, and that means, among other things, a single row of column headers. You need to fix the nested column headers, which you can do using Power Query, as explained in my Power Query Unpivot video tutorial.
In the attached file I've added some dummy values to your table so it's useful for answering your question. I've used Power Query to fix your nested column headers.
I hope that points you in the right direction.
Mynda
