Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] )
i believe its doable. can you please attach some mock data?