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: 
KIdriss
Contributor II
Contributor II

Get the first value of sum function

Hello,

I would like to know how to compare a value of a yearQuarter compared to the first yearQuarter.

- Dimension: colDate.autoCalendar.YearQuarter

- Measure:  comparison with the reference

I tried this but i get nothing:

( Sum(traf_aer_pax) - Aggr(Sum(traf_aer_pax), periodData.autoCalendar.YearQuarter) ) / Aggr(Sum(traf_aer_pax), periodData.autoCalendar.YearQuarter) 
Labels (1)
0 Replies