Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one please help me on below requirement.
I have a Date field like below.
I have extracted Month Year field from Date field like MonthName(Date) as [Year Month]
In the Bar chart
Dimension: [Year Month]
Measure: Count({<Reportdate=,Status={'Yes'}>}ID)
expected OUTPUT:
May2019= 2 (Actual Value)
Jun 2019 = May 2019+Jun 2019 = 2+60= 62
Sep 2019 = May 2019+Jun 2019+Sep 2019 = 2+60+13 = 75 etc...
Please help me on this.
Thanks in advance.
Hi
please go to the Data >> Measure >> ID >>Modifier >> set to Accumulation >>Range >> Set to Full
I have attached the output image as a table
Hope this helps
Thanks
Hi
please go to the Data >> Measure >> ID >>Modifier >> set to Accumulation >>Range >> Set to Full
I have attached the output image as a table
Hope this helps
Thanks