Thanks for looking into this.
Request you to please help me in refining the existing expression by adding the rangesum in it as mentioned in following screenshot-
Count(TICKET_ID) / COUNT ( TOTAL <CLOSED_MONTH_CALC> TICKET_ID)
above formula calculates the % per CLOSED_MONTH_CALC
we need to introduce running sum as mentioned below per CLOSED_MONTH_CALC -
Thanks for looking into this..
Thanks for the help. 🙂 & sorry for the continuous queries on this subject.
The above solution is working fine however there is another requirement.. I have added another row named as 'CLOSED_DATE' beneath CLOSED_MONTH_CALC which has dates in it(falling under month of CLOSED_MONTH_CALC ).
i want to calculate the runningsum for 'CLOSED_DATE' as well. Please recommend how it can be achieved :)-
* do i need to add something to below formula - ?
RangeSum(Before(Count(TICKET_ID) / COUNT ( TOTAL TICKET_ID), 0, ColumnNo()))
* Or need to add another measure?