cumulative count for each year month since start date

[agni_gold]

Hi Friends ,

I have a situation , i need to show count of ID's for current year with summation of old months records also , means running sum.

Please help

I have tried accumulation but when i select some year or month then it show only for that month count , but i want to show count from start date.

[MK_QSL]

What is the object you are using? Straight Table, Pivot table or Bar Chart.

Can you provide some sample data or sample app to work?

[agni_gold]

Bar chart and Straight table both

[MK_QSL]

Can you provide some sample data or sample app to work?

[agni_gold]

ok

[agni_gold]

here it is

[swuehl]

Have you considered using an AsOf table approach?

The As-Of Table

[agni_gold]

yes but , count is not coming from start date , if i select 2017 then Jan 2017 count should show from 1992 to 2017 Jan , similarly for 2017 Feb  , count should show from 1992 to 2017 Feb.

[swuehl]

The AsOf table should still show the correct cumulative value when you select a month. You need to use the AsOfMonth field as dimension, and also adapt your set analysis accordingly.

[agni_gold]

Could you please help here , attaching file