1 Reply Latest reply: Aug 21, 2018 2:39 PM by Simon Helie RSS

    Pivot table with filtered columns getting extra unknown column

    Simon Helie

      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.

       

      pivot table.png

       

       

      Here's how my pivot was built.

       

      pivot2.png

      I played with all the settings and couldn't get it fixed.

       

      Any help will be greatly appreciated.

       

      Thanks!

       

      Simon