How to get sum of data between two year .. Write the set analysis and ordinary expression

[Anonymous]

How to get sum of data between two year .. Write the set analysis and ordinary expression

[#2 · Accepted solution]

You could use constants:

Sum( {<Year={"=2014 =2015"}>} Sales )

Or values based on selections:

Sum( {<Year={"=$(=Max(Year)-1) =$(=Max(Year))"}>} Sales )

have a nice day

[buzzy996]

u can do both,I suggest set analysis.

[#4]

Hi,

Sum( {<Year={"=2014 =previous(2014)"}>} Sales )

i think this will work...y cant you try this