Using set analysis to get a value of previous period

[jaksaendo]

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

[PrashantSangle]

if you have year and quarter field in every row then showing previous quarter value for every row w.r.t dimension quarter year is not possible with Set analysis. You have to use above() or move the calculation in back end.

FYI. Set analysis evaluate value at table not at row level. that's why it is difficult.

Regards,

Prashant Sangle