Filter The Same Pivot Table Data 2 Ways

[dmcgetti]

I am new to using pivot tables, so bear with me...

My Data

Cust #	Sale Price	Return.CD
123	10	A
123	20
123	30	H

<tbody>
</tbody>

I have 3 columns in my pivot table that are all "Sum of Sale Price". I would like the first column to stay unfiltered, the second column to be filtered by "Return.CD" "A" and the last column filtered by "Return.CD" "H"

This would be my idea pivot table

Cust #	Sum of Sale Price	Sum Of Sale Price	Sum of Sale Price
123	60	10	30

<tbody>
</tbody>

I hope that makes sense and I appreciate any input!

Darren

 

[SpillerBD]

Not without PowerPivot.
You can drop "Return.CD" into your Column of the PivotTable. Grand Total is last column on right and all detail is shown, including the Blanks.

 

[dmcgetti]

Not without PowerPivot.

I was able to get PowerPivot and I have been trying to read up on it but it is rather confusing. Is there a short answer using PowerPivot or do I need to continue reading?

 

[SpillerBD]

you will be creating new Measures using the CALCULATE function.
Check the PowerBI forum section.
Other PowerBI references include PowerPivotPro - Transforming your Business with Power Pivot and Power BI
Blog - Excelerator BI

and ExcelIsFun Star, Mike Girvin at his YouTube Channel: YouTube