Hi community.
I'm stuck on the same project since 1 month.
I work on the workbook Clean Data.
On the worksheet Raw Data, I have all my raw data ordered by column (country, category of item, brand, name of item... end user price in EUR after VAT, GDP). The photo is not very clear.
Picture1.png
My source data must be the worksheet Raw data and update in my source data must update results of report.
I would like 3 different report:
Report 1: Top 5 highest price in France (with all informations: country, category of item, brand name, name of item... end user price in EUR after VAT, GDP)
Report 2: Top 5 lowest price in France (with all informations: country, category of item, brand name, name of item... end user price in EUR after VAT, GDP)
Report 3 (the most difficult one): Price difference per category of item compared to Cochlear
I tried to make pivot table but update of data is not intuitive.
Thank you for your answer. It's quite difficult, it could be grateful to help me.
Bookmarks