Pivot Table - Hide some rows to "Other"

[#1]

I have table:

Manager     Plan     Fact

Manager 1     100     150

Manager 2     200     220

Manager 3     0     100

Manager 4     0     80

If need table:

I need pivot table:

Manager     Plan     Fact

Manager 1     100     150

Manager 2     200     220

Other     0     180

I.e., if Fact = 0, I must display Manager "Other" instead of Name.

Help me, please!

[oknotsen]

Hi,

Remove Manager and add a Calculated Dimension instead with this code:

= if(Plan = 0, 'Other', Manager)

See attached.