Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
After setting up list boxes with alternate groups I now want to call the selections in a chart expression.
my code is:
Sum({$<{[OHRO]}[MARKET RISK: NOTE: on target + overdue = LIVE ISSUES]={'Red Threshold'},Getselectedfield from {[OHRO]}[Group]>}Data)
But I cant figure the item in red?
How do I 'getselectedfield'
Neil
Hi Neil,
I understand what you're asking, but it might be more helpful to go back to what you're first trying to achieve here.
How many states do you have? And what state is the chart in that you're mentioning? What do you want to be happening? If you can explain as fully as possible I can try and reference your questions in regards to what you want to use.
P() works to limit the calculation to only those selections that are possible in your given selected state - so rather than needing to select something from group, if group was a subset of a ABC and you selected a value in ABC, then only the groups that are possible from that selection would pass across, if that makes sense!