Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have information like the sample below and I am trying to make a table that looks like the second image.
The problem I am running into is the Savings is summing all the savings for every ID2, and if there are two results, it is only showing one, and the other is a null value. And if I bring in Results as a dimension, it gives me incorrect totals.
I have ID and ID2 as dimensions.
My expressions(that are working properly) are:
Max Year: Max({<[CAppeal?]={'Y'}>}[Year])
Years Since last Appeal: Year(Today(2))-Max({<[Appeal?]={'Y'}>}[Year])
Result: FirstSortedValue({<[CAppeal?]={'Y'}>} Result, -[Year])
Savings: FirstSortedValue({<[CAppeal?]={'Y'}>} Savings, -[Year])
try to check data type
can you make simple not clear
Result: FirstSortedValue({<[CAppeal?]={'Y'}>} Result, -[Year])
Savings: FirstSortedValue({<[CAppeal?]={'Y'}>} Savings, -[Year])
I tried using FirstSortedValue as some point, but was using the wrong fields. Thank you for your help.