topic FORMATTING REPORT in QlikView https://community.qlik.com/t5/QlikView/FORMATTING-REPORT/m-p/213157#M66954 <HTML><HEAD></HEAD><BODY><P>HI, I HAVE TWO DIMENSIONS</P><P>1. COUNTRY</P><P>2 CITY</P><P>DURING PARTIAL SUM , I REQUIRE THE ( <STRONG>COUNTRY_NAME &amp; 'TOTAL' )</STRONG></P><P>THAT MEANS IN PARTIAL SUM I WANT TO WRITE THE COUNTRY NAME &amp; TOTAL .</P><P>PLACE NAME OF COUNTRY IN COUNTRY NAME FIELD.</P></BODY></HTML> Sat, 04 Dec 2010 07:42:33 GMT 2010-12-04T07:42:33Z FORMATTING REPORT https://community.qlik.com/t5/QlikView/FORMATTING-REPORT/m-p/213157#M66954 <HTML><HEAD></HEAD><BODY><P>HI, I HAVE TWO DIMENSIONS</P><P>1. COUNTRY</P><P>2 CITY</P><P>DURING PARTIAL SUM , I REQUIRE THE ( <STRONG>COUNTRY_NAME &amp; 'TOTAL' )</STRONG></P><P>THAT MEANS IN PARTIAL SUM I WANT TO WRITE THE COUNTRY NAME &amp; TOTAL .</P><P>PLACE NAME OF COUNTRY IN COUNTRY NAME FIELD.</P></BODY></HTML> Sat, 04 Dec 2010 07:42:33 GMT https://community.qlik.com/t5/QlikView/FORMATTING-REPORT/m-p/213157#M66954 2010-12-04T07:42:33Z FORMATTING REPORT https://community.qlik.com/t5/QlikView/FORMATTING-REPORT/m-p/213158#M66955 <HTML><HEAD></HEAD><BODY><P>You can use alternate formatting for total rows by testing the rowno(). Pivot table subtotal rows have a rowno() of 0. Check out the QV Cookbook example "Alternate format for chart Total rows" sample for a complete example of this. You can download the Cookbook from<BR /><A href="http://robwunderlich.com/Download.html">http://robwunderlich.com/Download.html</A></P><P>-Rob</P></BODY></HTML> Sat, 04 Dec 2010 09:38:29 GMT https://community.qlik.com/t5/QlikView/FORMATTING-REPORT/m-p/213158#M66955 rwunderlich 2010-12-04T09:38:29Z