Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a selection made for Company, let's say Company A. I need an expression for a dimension that displays Company based on the Job and Rank. If Company A was rank 1 and Company B was rank 2, I need to show Company B. If Company C was rank 1 and Company A was rank 2 then I need to display Company A. I've been at this for hours and cannot figure it out. Thanks.
Job | Company | Rank | Low_Company |
1 | A | 1 | B |
1 | B | 2 | |
1 | C | 3 | |
1 | D | 4 | |
2 | C | 1 | A |
2 | A | 2 | |
2 | B | 3 | |
2 | D | 4 |
=if([Rank]>=2, sum(total <[Job]>{<[Rank]={1}>}Amount), sum(total <[Job]>{<[Rank]={2}>}Amount))
This works if I'm trying to do the same thing with a measure like [Amount] but I'm trying to do this for Company which is a dimension. I'm starting to think it isn't possible.