Filter by measure in SAP Analysis for Excel

[former_member334960]

Hi All,

I would like to filter the complete worksheet with a measure value(Eg: Measure>40)

I have gone through section 4.3.2 in the below link which shows various options to filter but it doesn't seem to work fine for me.

https://help.sap.com/doc/businessobject_product_guides_ams22_en_22sp4_analysisplugin_user_en_pdf/2.2...

Data in my report looks as below.

image.png

Can someone please let me know how a measure filter can be applied to the whole sheet.

Thanks.

Poojitha

[TammyPowlas]

Hello - which version/SP of Analysis Office are you using?

[former_member334960]

Hi Tammy,

I am using version 2.2.

[TammyPowlas]

Hello - 2.2 has been out for several years; please update to 2.5 or 2.6.