Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm having a pivot table where the columns are filtered like this:
=If(Match(Parameter.Name,'ABC','DEF','GHI','JKL'), Parameter.Name).
So I should be expecting 4 columns. But for some reasons I'm having an extra column with the values of "random" parameters.
Here's how my pivot was built.
I played with all the settings and couldn't get it fixed.
Any help will be greatly appreciated.
Thanks!
Simon
Issue is resolved. I had to uncheck "Include null values" on all rows/columns.
Issue is resolved. I had to uncheck "Include null values" on all rows/columns.