jessicacot
New Member
- Joined
- Sep 22, 2011
- Messages
- 3
I just created a pivot table (first time ) and I would like to be able to match either Opp #'s or Opportunity Name and then sum the weighted total.
Ex:
Opportunity Name Opp # Weighted Total
Silver Fish 1-2jiw $400.00
1-2jiw $ 50.00
1-2jiw $240.00
Subtotal
Black Cat 1-3wer $700.50
1-3wer $300.00
Subtotal
If I try to subtotal the field "weighted total" it subtotals the entire column. I need it to subtotal by each opportunity group or each opportunity # group.
Is this possible??
Thanks.
Ex:
Opportunity Name Opp # Weighted Total
Silver Fish 1-2jiw $400.00
1-2jiw $ 50.00
1-2jiw $240.00
Subtotal
Black Cat 1-3wer $700.50
1-3wer $300.00
Subtotal
If I try to subtotal the field "weighted total" it subtotals the entire column. I need it to subtotal by each opportunity group or each opportunity # group.
Is this possible??
Thanks.