Skip to Content
avatar image
Former Member

Display a measure in filter at analysis for office xls

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 21, 2017 at 03:21 PM

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

    Subhash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2017 at 03:38 PM

    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).

    Add comment
    10|10000 characters needed characters exceeded

    • 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.