Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
Can I ask a question regarding GetFieldselections in Set Analysis:
I have created an line load with possible selections( SDimensions)
=sum({<Type={'$(=GetFieldSelections(SDimensions))'},Month={<>}>}Units)/1000
How do I get the syntax to allow multiple selections because currently it will only allow one selection at a time.
This syntax is driving a bar graph output
Dear Community
I have managed to solve this, can I share:
In my In Line load I have added
load * Inline
[
SDimensions
"'Sales Achieved'",
"'JE Forecast'",
This allowed multiple selections
Thanks
instead of getfieldSelection() you can try with concat()
like
=sum({<Type={$(=Concat(chr(39)&SDimensions&chr(39),chr(44)))},Month=>}Units)/1000
Regards,