Hello, i am newbie here. Like to ask two questions
I have following data table
Month Person Quotes Sales Sales%
10 A 5 2 40%
10 B 5 0 0%
11 C 5 1 20%
12 D 5 1 20%
I created pivot table to display only following columns : Month Quotes Sales, and Sales %.
with Month being Drop down list at the top.
Question 1, the months displayed in the drop down list are in :
11
10
12
How can i modify it so that it will automatically display the months in increasing order ?
Question 2 . I added Grand Total feature , which will sum up all the columns.
Grand Total does help me sum up all quotes and sales count, but for my % , it is displaying 80% , which is wrong.
i really just want to display
the calculation, for all the months, the sales % in Grand total row will be ( 2+0+1+1)/ (5+5+5+5) * 100%= 20%
how can i modify to achieve my purpose ?
Thanks
TC
I have following data table
Month Person Quotes Sales Sales%
10 A 5 2 40%
10 B 5 0 0%
11 C 5 1 20%
12 D 5 1 20%
I created pivot table to display only following columns : Month Quotes Sales, and Sales %.
with Month being Drop down list at the top.
Question 1, the months displayed in the drop down list are in :
11
10
12
How can i modify it so that it will automatically display the months in increasing order ?
Question 2 . I added Grand Total feature , which will sum up all the columns.
Grand Total does help me sum up all quotes and sales count, but for my % , it is displaying 80% , which is wrong.
i really just want to display
the calculation, for all the months, the sales % in Grand total row will be ( 2+0+1+1)/ (5+5+5+5) * 100%= 20%
how can i modify to achieve my purpose ?
Thanks
TC
