Criteria/CountIf and Pivot Table

  • Thread starter Thread starter bdaoust
  • Start date Start date
B

bdaoust

Hello:

My data looks like this

ID Date CWA
Amount
1 08/12/2006 0
$0.00
2 08/13/2006 1
$10.00
3 08/14/2006 1
$20.00
4 08/01/2006 0
$0.00

Based on the above data, I want to create a pivot, by month (I know I
only have Aug here)
to show the following:

Sum of CWA
Count of CWA
Percent of cases that were submitted with CWA.

The CWA is an indicator field that looks at another field (not listed
here) to determine if there is cash in a column. If yes, 1, if not 0.

So my final pviot should look like this:

Jan Total Cases Submitted: 4
Total Cases Submitted With CWA:
Percent Submitted With CWA : 50%
Sum Of CWA : $30.00

Thanks,
Brian
 
Add a column to the source data, with the heading CWACount
Enter a 1 in each row, for that field
Add that field to the pivot table
Create a calculated field which divides CWA by CWACount
 
Back
Top