topic Cross tab style view in QlikView https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880758#M307332 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I am trying to replicate the table attached. I have business unit and year as dimensions . And sum of Sales as my expression. I believe you have to drag the year dimension above the expression to get the cross tab type of view but cant get it to work ? </P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 18 May 2015 14:00:34 GMT 2015-05-18T14:00:34Z Cross tab style view https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880758#M307332 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I am trying to replicate the table attached. I have business unit and year as dimensions . And sum of Sales as my expression. I believe you have to drag the year dimension above the expression to get the cross tab type of view but cant get it to work ? </P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 18 May 2015 14:00:34 GMT https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880758#M307332 2015-05-18T14:00:34Z Re: Cross tab style view https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880759#M307333 <HTML><HEAD></HEAD><BODY><P>Can you post a copy of your QlikView Application? Did you use a Pivot Table and then dragged the Year dimension?</P></BODY></HTML> Mon, 18 May 2015 14:03:51 GMT https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880759#M307333 petter 2015-05-18T14:03:51Z Re: Cross tab style view https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880760#M307334 <HTML><HEAD></HEAD><BODY><P>Hi Sid,</P><P></P><P>are you using a pivot table? See the attached</P><P></P><P>Andy</P></BODY></HTML> Mon, 18 May 2015 14:07:04 GMT https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880760#M307334 awhitfield 2015-05-18T14:07:04Z Re: Cross tab style view https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880761#M307335 <HTML><HEAD></HEAD><BODY><P>Peter and Andrew </P><P></P><P>Yes I am using a pivot </P></BODY></HTML> Mon, 18 May 2015 14:08:23 GMT https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880761#M307335 2015-05-18T14:08:23Z Re: Cross tab style view https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880762#M307336 <HTML><HEAD></HEAD><BODY><P>So I got into a cross tab form but how would it show the sub totals line by line as they are in the spreadsheet rather than just cumulative totals for 2014 and 2015 ?</P></BODY></HTML> Mon, 18 May 2015 16:28:38 GMT https://community.qlik.com/t5/QlikView/Cross-tab-style-view/m-p/880762#M307336 2015-05-18T16:28:38Z