This content has been marked as final. Show 4 replies
I am currently trying to have a chart title show the week ending date whenever a Financial Week is selected. With the data I have, I have to do this by selecting the highest day (DAY_DT) of the selected week (FINANCIAL_WEEK). The code I have written so far is:
If(GetSelectedCount(FINANCIAL_WEEK) >= 1, 'Wk Ending ' & ...
And this is where I am stuck. I have tried combinations with FirstSortedValue but nothing seems to work, and it just returns "Wk Ending " when a week is selected. Any suggestions?