Hi Everyone,
I have one excel file called as cross table.
Current Data Source:
From the excel source, with the below structure,
| School_Year | | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 |
ID | StudentName | Comments | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level | School | Level |
QlikView Chart Expectation:
I want the output as attached image.
Thanks
