Sum Next Quarter

[Oleg1990]

Hi

so basically i got a field Qrt in calendar that returns the quarter Q1-Q4.

i need to sum field OPP ACV by OPP Stage Number and the next quarter for what is filtered

 how do i set analysis function to calculate it based on the next quarter? so if i filter q1 the kpi will sum for q2

Sum({<[Opp Stage Number] = {3,4,5}>} [Opp ACV] )

[krishna_2644]

i believe its doable. can you please attach some mock data?