Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Divyanshu
Contributor II
Contributor II

Providing a range in set analysis

Hi all,

I have multiple quarters in my data and a filter of the quarter selection. I want a to get the sum of the sales between my first quarter in the data and the quarter I have selected on the filter. How can I provide the range of these 2 quarters in my set analysis expression.

 

Thanks in advance

Labels (2)
1 Reply
JuanGerardo
Partner - Specialist
Partner - Specialist

Hi @Divyanshu , probably with something like this:

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

JG