Help with a pivot

Question

Hello,I have a spreadsheet that has columns Deal Name, Owner, Phase 1, Phase 2, and Phase 3.&nbsp; The Phase columns will have the date the deal has completed that phase; so it can be blank if not completed yet.&nbsp; 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.&nbsp; Confused on how to pivot this?

mathetes · Answer

aaashton&nbsp;&nbsp;This seems to work:First the raw dataThen the pivot table instructions (dialog box)And the resulting pivot tableSpreadsheet attached&nbsp;

sergeibaklan · Answer

aaashton&nbsp;
In addition to&nbsp;mathetes&nbsp;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] &gt; 1,
    Table1[Phase2] &gt; 1,
    Table1[Phase3] &gt; 1
)

&nbsp;

Forum Discussion

Help with a pivot

2 Replies