Remove rows using Calculated Dimension

[#1]

Hello!

Could you please help me on how to remove rows in this (below) Pivot Table using a Calculated Dimension?

I want to remove GMM East and GMM West in Section 1, vice versa in Section 2, so the output will be like this (below) table:

GMMAREA is a data column from table file, while GMM1 and GMM are Inline loaded table. Attached is my script in .txt format.

Thank you!

[sunny_talwar · Accepted solution]

May be like this:

Replace GMMAREA with this:

If(GMM = 'Section 1', If(WildMatch(GMMAREA, '*South', '*North'), GMMAREA),

If(GMM = 'Section 2', If(WildMatch(GMMAREA, '*East', '*West'), GMMAREA)))

[#3]

This works. I checked Supress Null Values/Missing Values to exclude blank cells. Thanks!