I have a data sheet that I am trying to create a PivotTable from. I have the following Columns:
Campaign|Client| Date |Price|ClientLeads|Revenue
(Text) (Text)(mm/dd/yy) ($) (#) ($)
I want the PivotTable to look like this:
Month (Using Grouped Dates)
Client1
Campaign1 $4.00 10 (Sub) $40.00(Sub)
$5.00 2(Sub) $10.00(Sub)
Campaign2 $4.00 2(Sub) $ 8.00(Sub)
Client Totals 15(Total) $58.00(Total)
When I set the PivotTable up all I get is this:
Month (Using Grouped Dates)
Client
Campaign1 $4.00 2 $ 8.00(Sub)
3 $12.00(Sub)
5 $20.00(Sub)
$5.00 2 $10.00(Sub)
Campaign2 $4.00 2 $ 8.00(Sub)
Client Totals $58.00(Total)
First, how can I get just the sum of the ClientLeads next to the Prices?
Second, how can I get the total ClientLeads per Client next to the Client Total Revenue?
Another thing that I’m pulling my hair out over; When I group the dates, my drop list and what appears once a month is selected is formatted mmm, I would like to have mmmm; the full month name. I have tried reformatting the dates in the original data sheet and I have tried using the Number… formatting in the PivotTable and the cell that the PivotTable drop down list is in. Nothing works.
Campaign|Client| Date |Price|ClientLeads|Revenue
(Text) (Text)(mm/dd/yy) ($) (#) ($)
I want the PivotTable to look like this:
Month (Using Grouped Dates)
Client1
Campaign1 $4.00 10 (Sub) $40.00(Sub)
$5.00 2(Sub) $10.00(Sub)
Campaign2 $4.00 2(Sub) $ 8.00(Sub)
Client Totals 15(Total) $58.00(Total)
When I set the PivotTable up all I get is this:
Month (Using Grouped Dates)
Client
Campaign1 $4.00 2 $ 8.00(Sub)
3 $12.00(Sub)
5 $20.00(Sub)
$5.00 2 $10.00(Sub)
Campaign2 $4.00 2 $ 8.00(Sub)
Client Totals $58.00(Total)
First, how can I get just the sum of the ClientLeads next to the Prices?
Second, how can I get the total ClientLeads per Client next to the Client Total Revenue?
Another thing that I’m pulling my hair out over; When I group the dates, my drop list and what appears once a month is selected is formatted mmm, I would like to have mmmm; the full month name. I have tried reformatting the dates in the original data sheet and I have tried using the Number… formatting in the PivotTable and the cell that the PivotTable drop down list is in. Nothing works.