Results 1 to 4 of 4

Thread: slicer in pivot Table

  1. #1
    Neophyte hy1978's Avatar
    Join Date
    Nov 2018
    Posts
    2
    Articles
    0
    Excel Version
    2013

    slicer in pivot Table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hello,
    I want Slicer "Catalog Namber"
    Will be arranged from top to bottom as arranged in Table 2.
    And if I press on the Agant slicer
    The catalog number will be arranged from top to bottom as arranged in Table 2.
    The solution can also be with a macro code in the slice
    Thanks
    Attached Files Attached Files

  2. #2
    Conjurer Paul_Christie's Avatar
    Join Date
    Mar 2016
    Location
    Nottingham, UK
    Posts
    131
    Articles
    0
    Excel Version
    Office 365 Monthly update
    I'd like to point you to a single page on the web that tells you precisely what you want to know but I failed. I found this https://office-watch.com/2017/multip...l-pivottables/ which gave me a clue. Then I created a table out of the data on your data sheet and then with a cell in the table selected I selected the Insert Ribbon and from the windo that appeared I selected the Catalog Number and Agent options. I think that should do what you want.

    Regards
    Paul Christie
    Attached Files Attached Files

  3. #3
    Neophyte hy1978's Avatar
    Join Date
    Nov 2018
    Posts
    2
    Articles
    0
    Excel Version
    2013
    Thanks for your response.
    This is not what I need unfortunately.
    I need the numbers in "Number catalog" slicer Will be arranged as arranged in Table 2.
    If you click on David on the "agant" slices then the "catalog nambered" slicer will be arranged as arranged in table 2.


    I think the solution is to write a macro code in the slicer. I do not know how to do it.

  4. #4
    Conjurer Paul_Christie's Avatar
    Join Date
    Mar 2016
    Location
    Nottingham, UK
    Posts
    131
    Articles
    0
    Excel Version
    Office 365 Monthly update
    I get what you mean, you need the slicers to have knowledge of the Total column so that the slicers appear in descending Total order. I've just done a quick google and I'm getting the impression that you can't do what you want even with code. Sorry.

Posting Permissions

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