I have to find reason for failure per supplier,
Below is what I am trying to write:
{FIXED [Supplier]: RANK([Reason for failure])}
What is wrong?
1 answer
Rank in all its form is a table calculation - they are calculated last in the order of operation (step 10)
see https://jimdehner.com/2022/01/11/table-calculations-when-where-and-how/ - fixed lods are calculated in step 4
