+ Reply to Thread
Results 1 to 8 of 8

Create an advanced report to show average price per brand (sorted by country+ cat of item)

  1. #1
    Registered User
    Join Date
    11-07-2020
    Location
    Copenhague
    MS-Off Ver
    Microsoft office 365
    Posts
    83

    Smile 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.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Luu4466; 12-14-2020 at 03:06 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    6,593

    Re: Create an advanced report to show average price per brand (sorted by country)

    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

  3. #3
    Registered User
    Join Date
    11-07-2020
    Location
    Copenhague
    MS-Off Ver
    Microsoft office 365
    Posts
    83

    Re: Create an advanced report to show average price per brand (sorted by country)

    Quote Originally Posted by Keebellah View Post
    Hi, I havent looked at your file yet but have you tried a Pivot table?
    Thank you for your answer Keebellah. I want to avoid pivot table. I want to use formula.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    6,593

    Re: Create an advanced report to show average price per brand (sorted by country+ cat of i

    Okay, I'll see what I can do to help

  5. #5
    Registered User
    Join Date
    11-07-2020
    Location
    Copenhague
    MS-Off Ver
    Microsoft office 365
    Posts
    83

    Re: Create an advanced report to show average price per brand (sorted by country+ cat of i

    Hi. I found the solution. I will post the result soon.

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    6,593

    Re: Create an advanced report to show average price per brand (sorted by country+ cat of i

    Great, like to see it when you have it

  7. #7
    Registered User
    Join Date
    11-07-2020
    Location
    Copenhague
    MS-Off Ver
    Microsoft office 365
    Posts
    83

    Re: Create an advanced report to show average price per brand (sorted by country+ cat of i

    Hi everybody.
    The solution was to establish many double entry table.
    Attached Files Attached Files

  8. #8
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    6,593

    Re: Create an advanced report to show average price per brand (sorted by country+ cat of i

    Looks good

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Retrieve country and volume dependent price
    By pvp1900 in forum Excel General
    Replies: 6
    Last Post: 07-08-2018, 11:20 PM
  2. Creating a report country wise
    By gillani77 in forum Excel General
    Replies: 0
    Last Post: 10-29-2014, 11:10 PM
  3. Brand Map - Price and Volume Mapping - URGENT
    By allyshaik in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-02-2014, 03:43 AM
  4. Create report to show totals for vendors per month
    By skudera in forum Excel General
    Replies: 5
    Last Post: 12-15-2009, 02:28 PM
  5. table to show the average price macro
    By vaseny in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2008, 09:42 PM
  6. Retrieving the Price for a Specified Item and a Specified Brand
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 02:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1