I want to show QoQ sales in table and by default 1st quarter is null/infinity. But client want values for 1st quarter also specially when selected 2 or more quarters but not all. Is there any way when I select 2nd and 3rd quarter in filter on table shows
Hi @Prashant Lonkar,
If I'm reading this correctly, you are wanting to quarter-on-quarter values in your table, so q1 vs q2, q2 to q3, q3 to q4 etc, but this is failing for you as q1 is empty?
If so, an easy way around this is to use the Previous_Value() window calc - this is one such situation that previous_value excels at as this is one of reasons that the function was created for calculations where the first row in a set is null.
Previous_Value() can be quite hard to get your head around at first, so let us know if you need more help on this.
Steve
