Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have a dataset with the fields: Account_id, account_score, year_quarter, YearQuarterKey (which is a running sequencial number for every year-quarter combination). I want to use set analysis in a table presentation on my app, and to add the field previous_quarter_score to every row ! in the table, according the field YearQuarterKey
I tried:
=max( {< YearQuarterKey = {"$(=(YearQuarterKey-1))"} >} account_score)
It did not work.
Any thoughts on how to accomplish this?
Thanks
Set analysis work at table level not row level so in your scenario Set analysis will not work.
Try above(), below() or if()
Regards,
Prashant Sangle