Criteria/CountIf and Pivot Table

[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

 

[Debra Dalgleish]

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

 

[bdaoust]

Perfect!

You are helpful. I will be purchasing your book.

Thanks,
Brian

 

[Debra Dalgleish]

You're welcome! And thanks, I hope you like the book.

Perfect!

You are helpful. I will be purchasing your book.

Thanks,
Brian