Skip to Content
avatar image
Former Member

Autofill of cascading values in AO 2.2

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 13, 2017 at 01:36 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded