Results 1 to 2 of 2

Thread: "Intelligent" report filter

  1. #1

    "Intelligent" report filter

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

    Hi all

    I'm having problems sorting data using report filters in a PivotTable.
    I have a lot of organizational levels, and right now all org. units are shown when filtered.

    The solution I am searching for is some kind of intelligent report filter. Intelligent in the sence, that if I choose a specific organization on level 3, I only want the relevant (underlying) organizations on level 4 -> lvl. 5 and so on.

    How do I do so? I've tried to google my way out of it, but without luck.

    Thanks in advance!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Could you post workbook with your data and a small example of what you want to achieve, I think I understand but best to be sure.

Posting Permissions

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