Results 1 to 3 of 3

Thread: sorting Report Filter Drop-Down

  1. #1

    sorting Report Filter Drop-Down

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

    Hello all,
    I have a pivot table whose data is retrieved from a database. I want to have its report filter drop-down sorted in ascending order. I searched for it on the internet and found that we can sort the Report Filter drop-down by moving the Report Filter field to Row Lables section, sorting that field in Row Label section, saving, refreshing and restoring the field back to Report Filter section .

    But in my case, when I try to move Report Filter to Row Labels, I get an error saying "a pivot table report can not overlap another pivot table report."
    How should I go about it?

    Any help will be appreciated!
    Many Thanks

  2. #2
    update your sample or dump a screen

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Sounds like you have two pivots are they are very close. When you try to move the Report Filter, which is one line, to Row Labels, it will need many lines, and if that will overlap another pivot you get that message.

Tags for this Thread

Posting Permissions

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