Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following mall map:
Then I have something like:
STORE_ID | STORE | SALES | PERIOD |
---|---|---|---|
G04 | POLO | 50000 | 07/2017 |
G04 | POLO | 70000 | 08/2017 |
G05 | BURBERRY | 80000 | 07/2017 |
G05 | BURBERRY | 38000 | 08/2017 |
G08 | MANDARIN | 15000 | 07/2017 |
G09 | SWEET | 20000 | 07/2017 |
I want to know if there's any way to associate each STORE_ID from the table to the corresponding map, in order to show each STORE on the map where the background color would be GREEN or RED depending on SALES.
Do you know if that would be possible?
Thanks!!!
can you try this?
If(STORE_ID = P({<STORE_ID = {"=STORE_ID = P(SALES)"}>} STORE_ID), Green(), Red())