how to get last 2 year rolling store count in table

[sushil353]

Hi All,

I need to calculate count of stores for each year which opened in last to last year.

My input data is

Test:

Load * inline

[

Storeid,YearofOpen

1,2010

2,2010

3,2011

4,2011

5,2012

6,2013

7,2013

8,2014

9,2015

];

desired output:

Year	Store Count
2010	0
2011	0
2012	2
2013	4
2014	5
2015	7

It seems the logic is simple but I am not getting any clue to get it solved.

Please help to get the logic solved.

Thanks in advance

Sushil

[Anonymous · Accepted solution]

Yes, it is simple, see attached.

The expression is

rangesum(above(count(distinct Storeid),2, rowno()))

[#3]

Hi!

Try This:

Create a new table Chart

Define as Dimension: Storeid

Define one expresion as: Count( Distinct(Storeid))

Let me know If works!

Cheers!