Need Current Selection - 1

[Anonymous]

Hi, I need an expression to take the current selection and minus one. For example, if Fiscal Year 2018 is selected, I need the expression to automatically - 1 to 2017. If 2016 is selected it would show 2015 etc.

if(GetCurrentSelections([Fiscal - Year]),

Sum({$<[Fiscal - Year]=GetCurrentSelections([Fiscal - Year]-1)>}

[Amount - Shipped/Fulfilled USD]),

This is what I tried, but its not working. Any assistance would be great

[niclaz79]

Hi, try this:

Sum({<[Fiscal - Year]={$(=Max([Fiscal - Year])-1)}>}[Amount - Shipped/Fulfilled USD])

[Digvijay_Singh]

May be this -

if(GetSelectedCount([Fiscal - Year]),

Sum({$<[Fiscal - Year]={$(=Max([Fiscal - Year])-1)}>}[Amount - Shipped/Fulfilled USD]))