SAP Analytics Cloud comes with a built-in feature to checkbox that allows you to hide/unhide "Zero" values.
You also have the ability to hide/unhide "Null" values as well as to include "Unbooked" members from a table.
We have a requirement to create a switch that programmatically toggles between Hiding/Unhiding Zero values from the rows of a table. SAC designer tools comes with a such a widget (switch) but it requires scripting.
We cannot use APIs since the one available for this requires SAP BW as a source.
This solution will require scripting the code for the toggle switch to hide/unhide Zero values.
Assistance with this code would be highly appreciated.
Best to All