https://community.qlik.com/t5/QlikView/How-to-Structure-this-table/m-p/1587769#M443326 <P>You could do it with a straight table using no dimensions and three measures with no total aggregations. See picture below. I'll also attach a qvw file for reference.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13090i0F6A5AD6C00BA84D/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Mon, 03 Jun 2019 18:54:37 GMT Vegar 2019-06-03T18:54:37Z https://community.qlik.com/t5/QlikView/How-to-Structure-this-table/m-p/1587754#M443325 <P>If I have a table below</P><P>SaleID, Amount</P><P>1,500</P><P>2,300</P><P>3,5000</P><P>4,3000</P><P>5,1000<BR /><BR />I want it displayed like this</P><P>Key,Value</P><P>Sales ,5</P><P>Total Sales,10000</P><P>Average Sale, 2000</P><P>&nbsp;</P><P>I am struggling putting the key value in the table.&nbsp; I have researched pivot tables but I don't think this would be resolved with that.</P><P>Thanks,</P> Mon, 03 Jun 2019 18:01:49 GMT https://community.qlik.com/t5/QlikView/How-to-Structure-this-table/m-p/1587754#M443325 qlikofba 2019-06-03T18:01:49Z https://community.qlik.com/t5/QlikView/How-to-Structure-this-table/m-p/1587769#M443326 <P>You could do it with a straight table using no dimensions and three measures with no total aggregations. See picture below. I'll also attach a qvw file for reference.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13090i0F6A5AD6C00BA84D/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Mon, 03 Jun 2019 18:54:37 GMT https://community.qlik.com/t5/QlikView/How-to-Structure-this-table/m-p/1587769#M443326 Vegar 2019-06-03T18:54:37Z