Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an application where i have 2 measures as :
SalesDI1 and SalesDI2.
If all my dimensions are expanded, i want SalesDI1 to be visible and SalesDI2 to be invisible.
If only my R1 and D1 dimensions are there and all other dimensions collapsed then i want SalesDI2 to be visible and SalesDI1 to be invisible.
I tried acheiving that with dimensionality() but couldn't do that. Can anyone help em on this?
Thanks
Hi I don't think so based on dimensions expansion visibility will work out.
Based on selections may be visibility might work.
Dimensionality won't work here since it will always return zero outside the chart rows, and expression calculation conditional expression evaluates outside the chart rows. This might be possible with macro (not sure though), but that is not recommended. Read: Macros are Bad
Did you check if conditional dimensions will work?
Hey,
How wld conditional dimensions work ?
I think you will need to use a variable to control the dimension and expression visibility. You will probably also need a button to toggle the variable between the 2 states.
All dimensions (except R1 and D1) are conditional on the variable = 1
Expression 1 is conditional on the variable =1 and expression 2 on the variable = 0
The button action expression: =If(vToggle = 0, 1, 0)
Conditional Dimension will work something like;
SubStringCount('|'&Concat([% Fieldname],'|')&'|','|data|')
but conditional can work based on selection, but not on dimensions expansion
Hi,
Here Dimensionality won't work, also it is not suggestible to use the Macros, macros won't work in all the place. Instead you can try adhoc reporting. Check below link
Regards,
Jagan.
Hey,
Thanks but i don't understand your below statement:
"Dimensionality won't work here since it will always return zero outside the chart rows, and expression calculation conditional expression evaluates outside the chart rows." Can you plz explain?
Hey,
Thanks but we dont want an added button. Any other alternative?
thanks