Filter rows in Pivot Table

sqlpuzzle — Tue, 20 Apr 2021 18:43:17 GMT

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?

Re: Filter rows in Pivot Table

Marcos_Ferreira_dos_Santos — Fri, 23 Apr 2021 15:18:26 GMT

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