Skip to Content
0

Display a measure in filter at analysis for office xls

Aug 21, 2017 at 02:25 PM

44

avatar image
Former Member

Hi All,

I am creating a Analysis for Office xls report on one of the BW provider. I would like to display the filter on a measure(Open Quantity) in report sheet. I know that the filter can be applied at design panel and also on a table content.

Refer attachment for more details.

Thanks,

Srinivas.

filter-open-quantity-table.jpg

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Venkata Subhash Medisetty
Aug 21, 2017 at 03:21 PM
0

Insert Filter component for measures(available under Insert section in ribbon menu)

Subhash


capture.png (2.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 21, 2017 at 03:38 PM
0

Hi Venkat,

Thanks for your response, but in this scenario I have already selected one of the Measure(Open Quantity) by the given way. Here I would like to filter the value of that particular Measure(Open Quantity).

Ex:

Open Quantity

0

100

200

0

0

0

Here I would like to select only value '0' and same filter needs to be displayed at highlighted place(screen shot).

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Srinivas,

you need to use Filter by measure to achieve your requirement

right click on measure select Filter By measure->AllDimensionsIndependenty->Edit

and then choose operator you want and give value, Hope this works

Subhash

0
Former Member

Hi Venkat,

Thanks.

This will work to filter the entries in a filter. however we are trying to display the filter criteria on the above to the table(refer screen shot).

Srini.

0