Can we show "ALL" lable as a drop down in the slicers when we are showing all the data ???

[#1]

Hi All,

I have implemented security for my QV reports.

And i have given access for some of the users at top level means they can see all the data in the report.

So that time instead of showing all data in the drop down list (what am showing as of now from my multibox), i just want to show a level "ALL" at the top and then the under beneath data.

I know its possible in other BI tools like MSBI,cognos BI.

So is this possible in QV BI??

Any help will be appreciated.

Thanks & Regards,

Mahasweta

[#2]

without seeing your data, I had a similar problem recently where I needed to 'unrestrict' a field that was being filtered out with section access, and I was able to workaround that using the "star is" instruction. If you can post an example of your qvw I could try to be of more help.

[#3]

Hi Dragonauta,

Thanks for the help.

I have attached my QVW file here.Please solve the issue and reply me back.

Thanks,

Mahasweta

[#4]

what field are you using to filter with section access?

[#5]

I am implementing filter on Location, Business Group and Scenario.

Thanks,

Mahasweta