topic Complicated crosstable in QlikView https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/180300#M46775 <HTML><HEAD></HEAD><BODY><P>Hello, Anya.</P><P>see in my example:</P><P></P></BODY></HTML> Tue, 08 Jun 2010 11:54:04 GMT sparur 2010-06-08T11:54:04Z Complicated crosstable https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/180299#M46774 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P>I'm trying to load an Excel table (see attached example) that has budget/actual/forecast per period as column headers. I want to be able to create a report showing budgets and actual per period (per client). I've been trying to work it out useing the crosstable function but since the columns consist of 2 dimensions (period and actual/budget) I can't seem to work it out. Any help would be appreciated.</P></BODY></HTML> Tue, 08 Jun 2010 11:39:28 GMT https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/180299#M46774 2010-06-08T11:39:28Z Complicated crosstable https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/180300#M46775 <HTML><HEAD></HEAD><BODY><P>Hello, Anya.</P><P>see in my example:</P><P></P></BODY></HTML> Tue, 08 Jun 2010 11:54:04 GMT https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/180300#M46775 sparur 2010-06-08T11:54:04Z Complicated crosstable https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/180301#M46776 <HTML><HEAD></HEAD><BODY><P>That's exactly what I meant, thank you so much!</P></BODY></HTML> Wed, 09 Jun 2010 07:58:11 GMT https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/180301#M46776 2010-06-09T07:58:11Z