How to exclude one or more than one member on report?

[Former Member]

Post Author: izhar

CA Forum: WebIntelligence Reporting

Hi all group members, I am working on BOXI R2. I have to ask that, How to exclude one or more than one member from the report. I know there is function of filter, through which we can see our desired members and other remaining will be excluded, but that's filter. In some of tools i have seen just do right click on a specific member and click on "Exclude" option to exclude the member. Suppose i have placed a Time dimension on the report and standing on "Month Level" which has data from 1, 2, ... 7,8, ... 11, 12 Now i just have to exclude member 7 from the report. Can any member guide me here. Regards, Izhar

[Former Member]

Post Author: jsanzone

CA Forum: WebIntelligence Reporting

Izhar,

If you run the report in "modify" mode, then you have two options

1) You can click on the "Show/Hide Filter Pane" button which opens up the "apply filter" pane. From there you go to your Data panel and grab, drag, and drop an item from the Data panel into the apply filter pane and provide a constant or select a value to filter in or out from your report.

2) You can highlight the column of data that you want to filter on, then click on the "Add Quick Filter" button. Using the List of Values menu you either select one or multiple items that you want to include in the report.