Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to calculate based on current selection ?

Here is expression : sum ( sales) 

Here is dimension : Yr = ( 2015, 2016, 2017)

How do I write expression so it returns values for ANY YEAR selected  minus prior year ?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

sum({<Yr= {'$(=max(Yr))'}>}sales) - sum({<Yr= {'$(=max(Yr)-1)'}>}sales)

View solution in original post

1 Reply
Anonymous
Not applicable
Author

sum({<Yr= {'$(=max(Yr))'}>}sales) - sum({<Yr= {'$(=max(Yr)-1)'}>}sales)