Skip to Content
Dec 19, 2019 at 12:22 PM

Measure Filter Members using VBA

289 Views Last edit Dec 20, 2019 at 01:03 AM 2 rev

Hello SAP AfO Gurus.

Today I need your quick help please as I am trying to automate the functionality "Filter Members" (to hide/show measuers/columns instead of dimensions) using VBA.In my AfO report.

I have 2 queries: sheet (or query) 1 with Fiscal perdiod and measures M1, M2, M3 and is summary data let's say, and another sheet (or query) 2 that has document level data (Document num, Document item, CC, PC…) and which should only show one measure at time (M1 or M2 or M3) based upon the KPI from sheet1 the user has clicked on to move to sheet 2. I am using DoubleClick event to move from sheet 1 to sheet 2 this event is working fine.

I really appreciate any help.

Thank you and looking forward to reading you.