Mapping Year

[renjithpl]

HI All,

i have a table like;

AccountOpen	OpenYear	ClosedYear
AA1	2009	2012
AA2	2010	2012
AA3	2011
AA4	2012

So in my front end, i would like to have a chart with dimension as OpenYear (which is my base year) and in expression would be the count of accounts closed

in the above table two accounts have been closed in the year 2012,

so my graph should say,

OpenYear	Accounts Closed
2012	2

how can i achive this

[Gysbert_Wassenaar]

Use ClosedYear as dimension instead and count(ClosedYear) as expression.

[renjithpl]

I cant use as its mandatory here, and my application is huge and has other impacts..