show totals but suppress value in pivot table

[Anonymous]

I have scenario where

Product    type       Sales       

  A               P1       100

  B               P2        200

  A               P2        300

in the above table A is associated with P1 and P2, where I want to suppress P2 row, but want its to be included in totals like the table below

total       400  this is for A

P1          100

P2          300 (which is suppressed/hide)

total     200         for B

P2       200  it should be hide/suppressed   

john

[sunny_talwar]

Something like this:

Expression:

=If(SecondaryDimensionality() = 0, Sum(Sales), Sum({<type = {'P1'}>}Sales))

[Anonymous]

Hi Sunny if user selects Product B, then it has to display total but not B.

[sunny_talwar]

Like this?

or completely remove Product B?

[Anonymous]

completely remove product B, but display total as 200

[Anonymous]

Sunny, Is there a way where we can hide/squeeze  rows by using macro

[tresesco]

Like this?

[Anonymous]

Tresesco, its almost close, but if I select Product A, this has to show Product A with P1 as type and total, here my aim is to hide only P2 and its associated values.

[tresesco]

When nothing is selected?

[Anonymous]

It has to display Products where type is P1 and totals( this should have the P2 values in it)