1. TARGIT Community
  2. Community
  3. User Tips and Tricks
Knowledge Base

Overrule local criteria with filterbar

Marcel Reinert ·

I have added a local criteria to a table (4 JobRoles from one dimension), so that only the data of these 4 JobRoles are displayed. However, the customer would now like to be able to view the 4 JobRoles separately via the criteria bar/filter (the same dimension as the local criteria). But the filter does not respond due to the local criteria that have been set for the table. Only when I remove the local criteria does the selection of the dimension filter in the criteria bar have an effect again.

Is there a way to leave the global criteria selectable despite the local criteria of the same dimension? 

KR

Marcel

0

Comments

2 comments
Sort by DateVotes
  • Marlene Knaup

    Hi, there is a TARGIT blog post where the priority of the different filters is explained: 
    Criteria overrides – TARGIT Community

    Local criteria always overrides global criteria.

    0
  • Marcel Reinert

    Thanks for the link. I build a workaround that works fine for me so i can override a local criteria to "filter" on a specific element within the local criteria.

    I have another table from the dimension from which the criteria are built – without measures. I have filtered the table to only include the elements (also local) that are also contained in the report table. This means that when I click on an element in the “filter table,” I can drill down, and this also includes the report table and overwrites the local filters.

    I formatted the “filter table” so it is clean and then excluded it from the export, and now I can “filter” on an element and export only that from the report table.

    0
Please sign in to leave a comment.