topic Pivot Table Row back one dimension to get AVG in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Row-back-one-dimension-to-get-AVG/m-p/24027#M458634 <HTML><HEAD></HEAD><BODY><P>I have a list box with Year to user select, and then I break up Data throught dimensions in a pivot table. Dimensions like supplier, product, branch and finally Months (of the year selected in the list box). I want to compare the sums and Avgs of each month with the year. but when I use TOTAL, it skips all the other dimension and show the table totals not breaking by supplier, products..etc. How can I just row back just the last dimension (Months) to compare numbers between these others dimensions?</P></BODY></HTML> Tue, 30 Jan 2018 18:16:51 GMT Anonymous 2018-01-30T18:16:51Z Pivot Table Row back one dimension to get AVG https://community.qlik.com/t5/QlikView/Pivot-Table-Row-back-one-dimension-to-get-AVG/m-p/24027#M458634 <HTML><HEAD></HEAD><BODY><P>I have a list box with Year to user select, and then I break up Data throught dimensions in a pivot table. Dimensions like supplier, product, branch and finally Months (of the year selected in the list box). I want to compare the sums and Avgs of each month with the year. but when I use TOTAL, it skips all the other dimension and show the table totals not breaking by supplier, products..etc. How can I just row back just the last dimension (Months) to compare numbers between these others dimensions?</P></BODY></HTML> Tue, 30 Jan 2018 18:16:51 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Row-back-one-dimension-to-get-AVG/m-p/24027#M458634 Anonymous 2018-01-30T18:16:51Z