Filter The Same Pivot Table Data 2 Ways

[dmcgetti]

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

My Data
[TABLE="width: 500"]
<tbody>[TR]
[TD]Cust #[/TD]
[TD]Sale Price[/TD]
[TD]Return.CD[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]10[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]30[/TD]
[TD]H[/TD]
[/TR]
</tbody>[/TABLE]


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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Cust #[/TD]
[TD]Sum of Sale Price[/TD]
[TD]Sum Of Sale Price[/TD]
[TD]Sum of Sale Price[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]60[/TD]
[TD]10[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]

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