Creating a filter for single sheets in addition to the global filter

[#1]

Hello,

maybe someone can help me here.. at least i'm currently going crazy.

So i have a report with multiple sheets and one sheet for global filters.

The global filters are the main filters for all sheets.

However, since each sheet is standing for one department i want to have an additional filter for each sheet.

Example:

The sheet with the view of department A should show only the data of department A.

The sheet with the view of department B should show only the data of department B.

The data is seperated by the Dimension "FOLDER_NAME".

is there somehow a way where i can set a default filter that is set to FOLDER_NAME='Department_1' ?

Hopesomeone can help me...

[#2]

here you are:

[#3]

Attached an app, and it is working fine for me. Please test.

[kedar_dandekar]

Hi Susanne,

Please find attached with this mail a Qvw app with some sample data..

Though I think this is a work around to resolve your issue.. I have just further elaborated on Ramkumar's suggestion in the attached sample.

In the 'OnActivateSheet' trigger on each department sheets I have selected the dept and locked the field, and back on the global filter sheet I have added trigger to unlock and clear the department field selection.

HTH,

KD