It sounds a very easy issue, but I need some help. I have the following scenario:

Pivot 1:

Client

Price A

Price B

Difference

Client A

5

0

-5

Client B

5

5

0

Client C

5

5

0

Client D

5

0

-5

Total

20

10

-10

I need to suppress the clients that DIFFERENCE = 0, so having the following result Pivot:

Result Pivot:

Client

Price A

Price B

Difference

Client A

5

0

-5

Client D

5

0

-5

Total

10

0

-10

I have already tried something like "IF( PRICE B - PRICE A <> 0, SUM(PRICE A)) and IF( PRICE B - PRICE A <> 0, SUM(PRICE B))" in order to calculate the PRICE A and PRICE B, then the Clients that difference = 0 were suppressed. However, the TOTAL kept the same as has been shown above in Pivot 1.