topic Pivot Table row format in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-row-format/m-p/923063#M528923 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In a normal Pivot table how do i color particular rows ( all rows greater than 800) and sort the rows in a order.</P><P>Wanted to Highlight the rows 800 - 1000 and the dimension to be sorted as 0 -600,600 - 800 &amp; 800 - 1000</P><P>Attaching the QVW file for reference.</P><P></P><P>Have got the anser for my question but in the grouping currently i am showing number of agents in each bucket instead of it i need to show no of instances means if one agent has touched 0 -600 bucket tow days in teh month it should show two instrad of showing 1 as Average</P></BODY></HTML> Thu, 13 Aug 2015 13:29:59 GMT 2015-08-13T13:29:59Z Pivot Table row format https://community.qlik.com/t5/QlikView/Pivot-Table-row-format/m-p/923063#M528923 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In a normal Pivot table how do i color particular rows ( all rows greater than 800) and sort the rows in a order.</P><P>Wanted to Highlight the rows 800 - 1000 and the dimension to be sorted as 0 -600,600 - 800 &amp; 800 - 1000</P><P>Attaching the QVW file for reference.</P><P></P><P>Have got the anser for my question but in the grouping currently i am showing number of agents in each bucket instead of it i need to show no of instances means if one agent has touched 0 -600 bucket tow days in teh month it should show two instrad of showing 1 as Average</P></BODY></HTML> Thu, 13 Aug 2015 13:29:59 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-row-format/m-p/923063#M528923 2015-08-13T13:29:59Z Re: Pivot Table row format https://community.qlik.com/t5/QlikView/Pivot-Table-row-format/m-p/923064#M528924 <HTML><HEAD></HEAD><BODY><P>Hi Rajesh,</P><P></P><P>Check this file</P></BODY></HTML> Thu, 13 Aug 2015 17:13:02 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-row-format/m-p/923064#M528924 yura_ratu 2015-08-13T17:13:02Z Re: Pivot Table row format https://community.qlik.com/t5/QlikView/Pivot-Table-row-format/m-p/923065#M528925 <HTML><HEAD></HEAD><BODY><P>See the attached</P></BODY></HTML> Thu, 13 Aug 2015 17:22:40 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-row-format/m-p/923065#M528925 Kushal_Chawda 2015-08-13T17:22:40Z