Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - is it possible to use a selection as a look up value for other tables?
Example : On selecting a client's name, another table (containing all records) is filtered to that particular client's market segement
Yes.
You override the customer selection and then select from the possible market segment values.
Sum({<CustomerName =,MarketSegment = {$(=Concat(distinct chr(39) & MarketSegment & chr(39),','))}>}CYBookingAmount)
Thanks for the reply. I am half way there.
How do I get the market segment of the selected client? The plan is for the user to be able to select any of their clients and compare their performance with the client's segment.
The expression that I posted does that. Let's break it down a little.
Sum({<
CustomerName =, //Ignore the customer selection
MarketSegment = { //calculate the possible market segment values as a comma separated list enclosing each value in single quotes
$(= //Dollar Sign expansion forces this expression to calculate first
Concat(distinct chr(39) & MarketSegment & chr(39),',') //Concat makes a delimited list based on the possible values of Market Segment
)
}
>}
CYBookingAmount
)
Thanks that’s very useful.
I am getting a list of five possible market segments in the delimited list but I only want to return the one related to the client without any selections. What am I missing?