How to create a custom wizard capable of filtering worksheets?
Oh mighty RPAS Community
I'm trying to create a wizard that is capable of filtering worksheets by forecast level.
so if the user selects forecast level 01, it will only have access to the worksheets available for that level.
I have already defined a Pre-Range Mask that only shows 2 levels (01 and 21)
Mask=if (position([data].[flvl])=="flvl21" || position([data].[flvl])=="flvl01", true, false)
and i also added the property tag FLVLXX in the worksheets with the XX corresponding to the level value that I want.
The custom wizard group has 3 custom wizards (1- flvl, 2- prod, 3- loc) and it works fine apart from the filtering