Filter rows in Pivot Table

[sqlpuzzle]

Hi ,

I have a sample attached. I need to filter rows in the Pivot table when "#One" = "#Two".

I want to see only rows when "#One" & "#Two" are not equal.

How to do this?

[Marcos_Ferreira_dos_Santos]

Hi Sqlpuzzle ?

Have you solved this puzzle ?   I hope so.

A piece of advice would be to treat it in script/load time, whether by loading only the not equal, or by filling a calc dim "Equal" with Yes/No.

Best regards,

Marcos