HI all,
I could need some help, but I don't know if it is even possible.
Currently we use in a BI-IP workbook two levels on input. We use a filter setting in workbook function to give other chars filter values.
Example of the problem:
We've a layout with compcode, material and a keyfig
First we do input on compcode and material, both chars are in row so we can enter data.
Secondly we want to plan only compcode, with help of a function we put material to # (FILTER_VALUE_EXT). Causing material to be removed from layout.
Now we want to plan again compcode and material. So we remove filter value. ANd the issue is that the user need to put manually the material as drill down to rows.
Does someone now a need VBA trick or simple FIlter option for this? (Example is not respentative for problem, but is easiest to explain like this)
Thanks!
JvdP