So I have data summed up in a pivot but there are two possible outcomes, it's based on a ranking with feature A vs B. So an item can have ranking 9 with feature A, but can also have ranking 1 with feature B.
This data is shown in a pivot and I would like to have an outcome, thought of vlookup, where I can lookup the item and find the highest ranking. My pivots are split into pivot feature A and pivot feature B, I want to search the item in both pivots and have the highest outcome. So in this example outcome should be ranking 1.
It can also be the case that an item is not found in pivot feature A but is in pivot feature B, so I also need an iferror or something.
This data is shown in a pivot and I would like to have an outcome, thought of vlookup, where I can lookup the item and find the highest ranking. My pivots are split into pivot feature A and pivot feature B, I want to search the item in both pivots and have the highest outcome. So in this example outcome should be ranking 1.
It can also be the case that an item is not found in pivot feature A but is in pivot feature B, so I also need an iferror or something.