+ Reply to Thread
Results 1 to 2 of 2

How to make this in pivot table?/How to redo this in the pivot table

  1. #1
    Registered User
    Join Date
    08-25-2016
    Location
    France
    MS-Off Ver
    2013 Professional Plus
    Posts
    6

    How to make this in pivot table?/How to redo this in the pivot table

    Hi,

    So the idea is to improve the existing pivot table i have now. Basically there is a filter with which I filter the countries. Then when I filter the countries, there is another filter that I need to select to show values related to that. For example :

    Filter : Country : US/Europe/Asia

    Filter : Models : iPhone/Samsung/LG/Blackberry/HTC.

    Data (Rows) : Number of Users
    Data (Rows) : Number of Male Users
    Data (Rows) : Number of Female Users

    - Same Data Rows for all the countries and all models-


    Like this I have 5 different countries and 5 different models (same for all 5 countries), the data (rows) are same for all the models and all countries. So basically I want all 5 countries with their respective Data(rows) to appear when I select only the country. In the Pivot Table I have now I am forced to select the Models individually. I would like to have them appear one below other with their Data(Rows) like a tree structure.

    Thanks a ton for your help and suggestions in advance.

    It would be incredibly helpful for me.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to make this in pivot table?/How to redo this in the pivot table

    You get better result on your question if you add a small excel file, without confidential information.

    Please also add the expected results manualy in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Replies: 1
    Last Post: 08-26-2016, 04:08 AM
  2. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  3. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  4. Is it possible to make a Pivot Table from multiple Pivot Tables?
    By flapface in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-06-2014, 11:02 AM
  5. PLEASE DELETE this post
    By -EE- in forum Excel General
    Replies: 0
    Last Post: 02-22-2012, 07:46 PM
  6. to make a pivot table to work with an adjoining table
    By byronova in forum Excel General
    Replies: 2
    Last Post: 09-06-2009, 10:47 AM
  7. Change Variable data on 1 pivot table, make same changes in other pivot tables
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2008, 10:55 PM

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