Help with a pivot

[aaashton]

Hello,

I have a spreadsheet that has columns Deal Name, Owner, Phase 1, Phase 2, and Phase 3.  The Phase columns will have the date the deal has completed that phase; so it can be blank if not completed yet.  I want to count the number of Phase 1, Phase 2 and Phase 3 deals completed (only requirement is there is a date in this field) by Owner.  Confused on how to pivot this?

[#2]

@aaashton 

This seems to work:

First the raw data

Then the pivot table instructions (dialog box)

And the resulting pivot table

Spreadsheet attached

[#3]

@aaashton 

In addition to @mathetes and assuming you are not on Mac, to calculate all phases completed you may add data to data model creating PivotTable and use such measure

Completed :=
CALCULATE (
    COUNTROWS ( Table1 ),
    Table1[Phase1] > 1,
    Table1[Phase2] > 1,
    Table1[Phase3] > 1
)