topic Hopefully an easy Pivot Table formating question.... in QlikView https://community.qlik.com/t5/QlikView/Hopefully-an-easy-Pivot-Table-formating-question/m-p/396078#M1149969 <HTML><HEAD></HEAD><BODY><P>I would like my results displayed as:</P><P></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |Whse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">Channel&nbsp;&nbsp; |A&nbsp;&nbsp;&nbsp;&nbsp; |B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">Domestic&nbsp; |&nbsp; $$$ |&nbsp; $$$&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">Export&nbsp;&nbsp;&nbsp; |&nbsp; $$$ |&nbsp; $$$ </SPAN></P><P></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">Where $$$ is the sum of Sales</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">What I always seem to get is:</SPAN></P><P></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">Channel</SPAN>&nbsp;&nbsp; |Whse&nbsp; |Sum(Sales)</SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">Domestic</SPAN>&nbsp; |A&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |B&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">Export&nbsp; </SPAN>&nbsp; |A&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |B&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$ _&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Wed, 22 May 2013 14:35:23 GMT hobanwashburne 2013-05-22T14:35:23Z Hopefully an easy Pivot Table formating question.... https://community.qlik.com/t5/QlikView/Hopefully-an-easy-Pivot-Table-formating-question/m-p/396078#M1149969 <HTML><HEAD></HEAD><BODY><P>I would like my results displayed as:</P><P></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |Whse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">Channel&nbsp;&nbsp; |A&nbsp;&nbsp;&nbsp;&nbsp; |B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">Domestic&nbsp; |&nbsp; $$$ |&nbsp; $$$&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">Export&nbsp;&nbsp;&nbsp; |&nbsp; $$$ |&nbsp; $$$ </SPAN></P><P></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">Where $$$ is the sum of Sales</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">What I always seem to get is:</SPAN></P><P></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">Channel</SPAN>&nbsp;&nbsp; |Whse&nbsp; |Sum(Sales)</SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">Domestic</SPAN>&nbsp; |A&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |B&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;"><SPAN style="text-decoration: underline; font-family: courier new,courier;">Export&nbsp; </SPAN>&nbsp; |A&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="text-decoration: underline; font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |B&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; $$$ _&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Wed, 22 May 2013 14:35:23 GMT https://community.qlik.com/t5/QlikView/Hopefully-an-easy-Pivot-Table-formating-question/m-p/396078#M1149969 hobanwashburne 2013-05-22T14:35:23Z Re: Hopefully an easy Pivot Table formating question.... https://community.qlik.com/t5/QlikView/Hopefully-an-easy-Pivot-Table-formating-question/m-p/396079#M1149970 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can click on the Whse header on your chart and drag it up until the red line changes to horizontal.This will place Whse on the top axis.</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Wed, 22 May 2013 14:39:53 GMT https://community.qlik.com/t5/QlikView/Hopefully-an-easy-Pivot-Table-formating-question/m-p/396079#M1149970 jonathandienst 2013-05-22T14:39:53Z