Filter Power Pivot by column value (of sub field)

[Kroneborge]

Hi,

I have a power pivot with two fields in the value section that is further sub divided by an additional field in the column section. Basically we have item transactions (volume and revenue), with multiple types (sales, dump, and destroyed). I want to filter so that items that don't have a dump or destroyed volume or hidden. But when I try and filter by value I only get the option to filter by either volume or revenue. When what I really need is extra conditions. basically something like filter if volume dump OR volume destroyed not equal to zero.

Things I've considered. I think you should be able to do this in with a measure in Dax, but I'm having a hard time getting my head around it. Or maybe just write a macro to hide them. But I would prefer to use built in pivot table functionality is possible.


Thanks,


[TABLE="width: 614"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]3 Dumps[/TD]
[TD]3 Dumps[/TD]
[TD]2 Damaged[/TD]
[TD]2 Damaged[/TD]
[TD]Sales[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]ItemNo[/TD]
[TD]ItemDesc[/TD]
[TD]Revenue[/TD]
[TD]Quantity[/TD]
[TD]Revenue[/TD]
[TD]Quantity[/TD]
[TD]Revenue[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD]01112[/TD]
[TD]Item 1[/TD]
[TD] 7[/TD]
[TD] 2[/TD]
[TD][/TD]
[TD][/TD]
[TD] 4,190[/TD]
[TD] 1,383[/TD]
[/TR]
[TR]
[TD]01163[/TD]
[TD]Item 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 60[/TD]
[TD] 22[/TD]
[/TR]
[TR]
[TD]01201[/TD]
[TD]Item 3[/TD]
[TD][/TD]
[TD][/TD]
[TD] 20[/TD]
[TD] 2[/TD]
[TD] 1,574[/TD]
[TD] 664[/TD]
[/TR]
</tbody>[/TABLE]