Hello everyone !
I have a table containing order N°, Order date, Item, State, State Date
I would like to be able to display only the latest STATE of the ITEM based on the date
At the moment, the pivot table looks like this
ORDER N° ITEM STATE STATE DATE
AAA1 403 01.01.2018
0001 AAA1 407 05.01.2018
AAA2 403 06.01.2018
AAA3 403 02.01.2018
AAA3 407 03.01.2018
0002 BBB1 403 06.01.2018
BBB1 407 08.01.2018
BBB2 401 31.12.2017
BBB2 403 02.02.2018
The table should only display States that are the most recent >
Thank you for your help
How can I change background color using this expression ?
Obviously, if I try to put a if statement on the STATE (if STATE='401'....) it won't work as each ITEMS have 2 or more STATE
How to use the Expression to check the value, then the color of the cell ?
I have the same question and your solution works fine but the performance with a big table is very bad.
There is another solution for this case? Perhaps, order the table on script and another function with a better performance?
Thanks a lot