Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I would like to select a "Goal" in the Goals listbox, as so:
and change this layout
to this layout
Does anyone know how I could accomplish this?
Thanks in Advance,
Preston
Hi Preston,
You can use below expression in Conditional show property of the chart. Check the attachment and adapt the same for all charts.
=Count(DISTINCT {<Type={'Measure'},ID={'1.2*'}>} [Measure Name])
Hi Preston,
You can use below expression in Conditional show property of the chart. Check the attachment and adapt the same for all charts.
=Count(DISTINCT {<Type={'Measure'},ID={'1.2*'}>} [Measure Name])
Hi Preston,
And I also think that you can create a variable, for example named v1,
then using :
v1=if(Goals='Mission Specific',1,0)
then using the v1=1 then show the Mission Measures in condition.And 0 show another list box.
Aiolos Zhao
Thanks Tamil for the solution! I really appreciate it.
Regards,
Preston
Aiolos,
I never thought about using the variable, but I think I'll combine it with Tamil's answer above to really work some mags with what I'm trying to do.