+ Reply to Thread
Results 1 to 3 of 3

Slice multi-column ranked relational pivot

  1. #1
    Registered User
    Join Date
    02-07-2016
    Location
    Barcelona. Espaņa
    MS-Off Ver
    2016
    Posts
    20

    Slice multi-column ranked relational pivot

    I have a set of several sheets for different metrics with multi-year tables of data where columns are for months because there's 15k+ rows of products, which are always in the same order throughout all the metrics' sheets (same with dates, ofc). I'd like to be able to present the data through several pivot charts all dependent on one pivot table where I can have 1 slicer for months+another for weeks if they're the date attribute used and 1 slicer for the different metrics (amount of buyers, revenue, net revenue, etc); extra points, there's a combined product category which is always the top ranked, I'd love to have a slicer for "with" "without" combined product if possible.
    I'd imagine having both Months and Weeks would be ideal, but that would complicate things a bit further (?) as the same month value reaps for every ~4 weeks, but it'd be great to slice through either attribute.
    Any comment, observations or collab would be greatly appreciated

    Note: this has also been posted on StackOverflow
    Attached Files Attached Files
    Last edited by correa.cristobal; 04-22-2019 at 03:53 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Slice multi-column ranked relational pivot

    Please provide the exact crosspost link to StackOverflow. The link provided does not work.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-07-2016
    Location
    Barcelona. Espaņa
    MS-Off Ver
    2016
    Posts
    20

    Re: Slice multi-column ranked relational pivot

    Done. Cheers alan

+ 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. Multi-column dropdown list using multi-column dynamic range (no VBA)
    By ysdai7287 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-04-2018, 03:59 AM
  2. [SOLVED] i need a function which will return results from right hand side of ranked column
    By zaahideen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2017, 08:22 AM
  3. Ranked column of numbers (1 up to 15) which come up as 1,2,3,3,5,6,7,8,9,9
    By Securitysports in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-04-2013, 01:53 AM
  4. Extract ranked data from pivot
    By Langoo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 08:25 AM
  5. Pivot table using multi-value column
    By inomata in forum Excel General
    Replies: 1
    Last Post: 09-30-2010, 03:46 AM
  6. Pivot Tables for Multi-Column Range
    By duGly in forum Excel General
    Replies: 2
    Last Post: 09-13-2010, 02:43 PM
  7. Row and column labels of ranked data
    By Ulrich in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2010, 10:39 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