I have a pivot table referencing referrals into our company
In the grand total column, I have total number of referrals for the year
is there a way to group the data in my pivot table by grand total? "Group" is not an option when I right click the data in the grand total coumn
Hi Dan,
By "grouping" do you mean you want Sub Totals for each category / product / date, etc. ?
Regards
peterrc
May be Data base function much useful for the same instead of Pivot table.
Select the whole data then press Alt->D->B then click on yes ->> you will get a window subtotal->>> check mark on each calculation field->>> use function what ever your choice ->>> for grouping select in at each change in then ok..
By above step you will retrieve the subtotal according your group and you will have some tab num 123 in left corner below name box, you can easily check group wise product wise of grand total wise data.
Hope this will help
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
what I'm needing is basically a list of all referral sources with 1-5 referrals, and 6-10 referrals, 11-15 etc
You get better help if you add an small excel file, without confidential information.
Please also add the result manualy in the file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks