Create an advanced report to show average price per brand (sorted by country+ cat of item)
Hi community.
I'm working on the workbook "Dashboard".
I'm working on the worksheet "GLOBAL".
Many people helped me a lot for previous report but i have too much data in my report.
I want to create one report (solution A) or many reports (solution B) which show the following thing:
- Average price per brand sorted by country and by category of item (USA together, BRAZIL together... and antenna together, antenna cable together) based on the worksheet "Raw data".
Have a good day.
Last edited by Luu4466; 12-14-2020 at 03:06 AM.
Hi, I havent looked at your file yet but have you tried a Pivot table?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thank you for your answer Keebellah. I want to avoid pivot table. I want to use formula.Originally Posted by Keebellah
Okay, I'll see what I can do to help
Hi. I found the solution. I will post the result soon.
Great, like to see it when you have it
Hi everybody.
The solution was to establish many double entry table.
Looks good
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks