topic Format Sum and partial sums in QlikView https://community.qlik.com/t5/QlikView/Format-Sum-and-partial-sums/m-p/241655#M92048 <HTML><HEAD></HEAD><BODY><P>So you want your sum or partial sum formatted differently than the other values? I'm not sure there's a simple, direct way. However, you should be able to use dimensionality() to accomplish the same thing. Let's say your pivot table has two dimensions. Then the dimensionality of the detail rows will be 2, the partial sum will be 1, and the total will be 0. So you should be able to do something like this (untested):</P><P style="padding-left:30px;">num(sum(Value),pick(dimensionality()+1,'#,##0','#,##0.00','$#,##0'))</P><P>And make sure you don't override the format on the Number tab.</P></BODY></HTML> Wed, 04 Aug 2010 18:49:30 GMT johnw 2010-08-04T18:49:30Z Format Sum and partial sums https://community.qlik.com/t5/QlikView/Format-Sum-and-partial-sums/m-p/241654#M92047 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Does anyone know how to format sum and partial sum in a pivot table?</P><P>So far I can only format/change the name of the Sum in another word for not format the figure itself.</P><P>I looking forward to reading your input.</P><P>Thanks and Best Regards.</P><P>ABG</P></BODY></HTML> Wed, 04 Aug 2010 18:22:57 GMT https://community.qlik.com/t5/QlikView/Format-Sum-and-partial-sums/m-p/241654#M92047 2010-08-04T18:22:57Z Format Sum and partial sums https://community.qlik.com/t5/QlikView/Format-Sum-and-partial-sums/m-p/241655#M92048 <HTML><HEAD></HEAD><BODY><P>So you want your sum or partial sum formatted differently than the other values? I'm not sure there's a simple, direct way. However, you should be able to use dimensionality() to accomplish the same thing. Let's say your pivot table has two dimensions. Then the dimensionality of the detail rows will be 2, the partial sum will be 1, and the total will be 0. So you should be able to do something like this (untested):</P><P style="padding-left:30px;">num(sum(Value),pick(dimensionality()+1,'#,##0','#,##0.00','$#,##0'))</P><P>And make sure you don't override the format on the Number tab.</P></BODY></HTML> Wed, 04 Aug 2010 18:49:30 GMT https://community.qlik.com/t5/QlikView/Format-Sum-and-partial-sums/m-p/241655#M92048 johnw 2010-08-04T18:49:30Z Format Sum and partial sums https://community.qlik.com/t5/QlikView/Format-Sum-and-partial-sums/m-p/241656#M92049 <HTML><HEAD></HEAD><BODY><P>nice one John .. Thanks</P></BODY></HTML> Sat, 19 Feb 2011 22:27:34 GMT https://community.qlik.com/t5/QlikView/Format-Sum-and-partial-sums/m-p/241656#M92049 amien 2011-02-19T22:27:34Z