topic Pivot Table Layout in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Layout/m-p/186955#M50824 <HTML><HEAD></HEAD><BODY><P>This post is something similar to one I posted a while ago.</P><P>My user has asked me to try and produce something similar to the attached excel file.</P><P>My data source is a transactional sales invoice qvd database.</P><P>Replicating columns A, B, C and D is very straightforward.</P><P>"Region" and "FY" (Financial Year) are dimensions with Sales, Gross Profit and GM% being expressions.</P><P>The problem comes when I try to add columns E and F.</P><P>These will be expresssions with the logical place for the pivot to add them being below Sales, Gross Profit and GM%.</P><P>As I previously stated, I did have a similar issue which i posted on the forum - this was solved by creating a summary table - was just interested in seeing if there was another solution to this issue.</P><P></P></BODY></HTML> Fri, 03 Sep 2010 09:01:51 GMT pkelly 2010-09-03T09:01:51Z Pivot Table Layout https://community.qlik.com/t5/QlikView/Pivot-Table-Layout/m-p/186955#M50824 <HTML><HEAD></HEAD><BODY><P>This post is something similar to one I posted a while ago.</P><P>My user has asked me to try and produce something similar to the attached excel file.</P><P>My data source is a transactional sales invoice qvd database.</P><P>Replicating columns A, B, C and D is very straightforward.</P><P>"Region" and "FY" (Financial Year) are dimensions with Sales, Gross Profit and GM% being expressions.</P><P>The problem comes when I try to add columns E and F.</P><P>These will be expresssions with the logical place for the pivot to add them being below Sales, Gross Profit and GM%.</P><P>As I previously stated, I did have a similar issue which i posted on the forum - this was solved by creating a summary table - was just interested in seeing if there was another solution to this issue.</P><P></P></BODY></HTML> Fri, 03 Sep 2010 09:01:51 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Layout/m-p/186955#M50824 pkelly 2010-09-03T09:01:51Z