Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Transpose/Dynamic Columns based off Slicer

Hi, Im trying to transpose my data and have the columns shown be dynamic based off a related slicer My base data looks like this: I then transpose to this, which is the format I'm looking to...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the suggestion! Unfortunatley I still cant seem to limit what columns are displaying after transposing/pivoting a column. I can get the data to pivot correctly, but limiting what columns display after the pivot is still a problem.

     

    i.e. Slicer selction 1 has records for contract plan H1036_137 and H1036_167. When i pivot the data, I have columns for these two contracts plans (which is what I want to include) and all the other contract plans (which is what I do not want to include). Is there a way to limit the colums displayed to solely whats correlated to the slicer?

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      ImkeF , can you help on this.

      • ImkeF's avatar
        ImkeF
        Community Champion
        6 years ago

        Hi Anonymous#w ,

        having difficulties to understand what's requested here. 

        First impression was that you shouldn't unpivot your data.

        You're starting from a table with a defined structure and fixed number of columns and transform it to a table with an unknown number of columns (and therefore column names). Why do you do that?