topic pivot table issue...... in QlikView https://community.qlik.com/t5/QlikView/pivot-table-issue/m-p/345624#M1173716 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>i am facing a situtaion in which i need advice in detail to check the fiisibility of the use of pivot chart in my case..if yes then how ???</P><P></P><P>in my&nbsp; case i am fetching a column 'provider' from database and using it as a dimension in pivot table...now what i need in my chart is to show the top 10 providers on the basis of a column named 'membercnt'....then in the same pivot table i need to perform calculations on another column named 'amount'</P><P>and in the pivot table the column will be created as p1,p2...p10 and in each column different expressions will be executed on the allowed amount...</P><P></P><P>now the main problem is that i have to show the total of top10 rows,total of the remaining rows and the complete total in the same pivot table???/</P><P></P><P>how can i achieve that???? </P></BODY></HTML> Thu, 10 May 2012 08:49:33 GMT 2012-05-10T08:49:33Z pivot table issue...... https://community.qlik.com/t5/QlikView/pivot-table-issue/m-p/345624#M1173716 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>i am facing a situtaion in which i need advice in detail to check the fiisibility of the use of pivot chart in my case..if yes then how ???</P><P></P><P>in my&nbsp; case i am fetching a column 'provider' from database and using it as a dimension in pivot table...now what i need in my chart is to show the top 10 providers on the basis of a column named 'membercnt'....then in the same pivot table i need to perform calculations on another column named 'amount'</P><P>and in the pivot table the column will be created as p1,p2...p10 and in each column different expressions will be executed on the allowed amount...</P><P></P><P>now the main problem is that i have to show the total of top10 rows,total of the remaining rows and the complete total in the same pivot table???/</P><P></P><P>how can i achieve that???? </P></BODY></HTML> Thu, 10 May 2012 08:49:33 GMT https://community.qlik.com/t5/QlikView/pivot-table-issue/m-p/345624#M1173716 2012-05-10T08:49:33Z