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?
