Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get sum of data between two year .. Write the set analysis and ordinary expression
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
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
u can do both,I suggest set analysis.
Hi,
Sum( {<Year={"=2014 =previous(2014)"}>} Sales )
i think this will work...y cant you try this