Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have the below expression however it only uses the last "identifier" rather then all of them.
Sum ({$<[concepts_id]={'258'},[identifier]={'ES0081'},[identifier]={'ES0065'},[identifier]={'ES0231'},[identifier]={'ES0182'},[identifier]={'ES0128'},[identifier]={'ES0075'},[identifier]={'ES0049'},[identifier]={'ES0198'},[identifier]={'ES0224'}>}Sales_value)
So I want a sum of concept_id 258 but only include those identifiers.
Thanks
Like this:
Sum ({$<[concepts_id]={'258'},[identifier]={'ES0081','ES0065','ES0231','ES0182','ES0128','ES0075','ES0049','ES0198','ES0224'}>}Sales_value)
I am using this on a combo chart and I want that expression the ignore any selection. So when I select Idenifier ES0182, the above expression still calculates the Sum of them all but I have another line that just calculates the sum of the selected identifier.
I'm not sure what your question is....
If it's how to calculate the sum of the selected identifier on the other line, just erase the identifier= bit out of the expression, so
Sum ({$<[concepts_id]={'258'}>}Sales_value)
If this is not your question please try to explain what is.