Showing other data in Pivot Table

Hi,

Not sure why Nancy Lim, for example, has different entries for her phone number? In any case, you'll need to add your data to the Data Model and recreate your Pivot Table using Power Pivot, with the following two measures:

PHP Code: 

Email :=
VAR ThisSalesRep =
    MIN( MLS_Data[Sales Rep] )
RETURN
    CALCULATE(
        MIN( MLS_Data[E-mail] ),
        FILTER(
            MLS_Data,
            MLS_Data[Sales Rep] = ThisSalesRep
                && MLS_Data[E-mail] <> ""
        )
    ) 


PHP Code: 

PhoneNumber :=
VAR ThisSalesRep =
    MIN( MLS_Data[Sales Rep] )
RETURN
    CALCULATE(
        MIN( MLS_Data[Phone Number] ),
        FILTER(
            MLS_Data,
            MLS_Data[Sales Rep] = ThisSalesRep
                && MLS_Data[Phone Number] <> ""
        )
    ) 


which can then be dragged into the Values area of the Pivot Table.

These could be greatly simplified were there no duplicate entries in those columns, i.e., in your case, duplicate blanks.

Regards

It would be a lot simpler just to add them in as row fields before the value fields?

If you're entering the measures via the Calculation Area in the Power Pivot window then you can paste the formulas precisely as I give.

If instead you're entering them via the Power Pivot tab (Measures/New Measure) in the Excel window then you exclude the name part (for example, "Email :=") when you enter the formula into the box.

Regards