how to show previous year sales based on current selection?

[Akina0929]

Hi ,

I have 7 years of sales data , i want to show the sales based on current selection ,if i select 2015 it should show 2014 sales like...

Thanks&Regards

Anji

[tripatirao]

Hi,

Please share some sample data to work on this.

Rgs

Tripati

[Akina0929]

!

[devarasu07]

[tresesco]

Try expression like:

Sum({$<year={"$(=getfieldselections(year)-1)"}>}sales)                // to go with your expression

Or,

Sum({$<year={"$(=Max(year)-1)"}>}sales)          // this would also work when no/multi selection is done, unlike yours way

[dinuwanbr · Accepted solution]

Hi Anji,

Check this

[Akina0929]

thank you