Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table where I store the yeara client join a group (YearIn) and the date the client left the group (YearOut).
How can I create a chart where I have years in dimension and in expression I want the number of client who joined each year and the number of client who left each year?
I hope it is clear.
Any ideas?
Thanks
Hi
Can you post a sample file in it? Its easy to refer it. Or can you post a table viewer?
Hi,
Here are some sample talbe :
Client table :
Client Name YearIn YearOut
Smith 2010 2012
Jack 2009 2011
Martin 2009 2012
Evans 2008
Newton 2010 2011
Calendar table:
Year
2008
2009
2010
2011
The chart I want will look like this:
Nb client In Nb client Out
Year
2008 1 0
2009 2 0
2010 2 0
2011 0 2
2012 0 2
Hi
You may create table from "Client table"
-----
ClientName, Year, Type
Smith, 2010, In
Smith, 2012, Out
......
And use expressions with 'Set Analysis'
I wanted to know if it was possible to do that without creating a new table.