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.



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


      Any help will be greatly appreciated.