Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)))
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)))
This works. I checked Supress Null Values/Missing Values to exclude blank cells. Thanks!