Skip to Content
0

Autofill of cascading values in AO 2.2

Jan 13, 2017 at 01:26 PM

50

avatar image

HI Experts,

I am using AO2.2 to fulfill one of my requirement would like to take your ideas regarding my issue.so here we go

actually i have total 10 filters (cascading) for example if i am selecting sales org corresponding Project no will come if i select project no corresponding Machine type will come and so on ...please find screenshot below. so here my requirement if user select sales org what are corresponding values should auto fill in top of my sheet(please check screenshot)


in below screenshot if i select sales org under filters for

drill down button then corrosponding all values(project no machine type and so on) should come and sit in top

(in this place)

is there any way where we can achieve this ?

can we write macros for auto fill values

and my second requirement i need to have button once user selects that button automatically all filter values should cleared and go back to intitial state

is this possible?

could any one guide me here that would really help me

Thanks,

varun

qsncf.png (36.0 kB)
tnl86.png (7.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Jan 13, 2017 at 01:36 PM
0

Varun - I recommend starting small, and trying it yourself with your own data - see https://blogs.sap.com/2013/04/27/how-to-setfilter-with-analysis-office-macros/

Have you tried this yourself or searched for this?

Share
10 |10000 characters needed characters left characters exceeded