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?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

        Thanks for the feedback! The way the data is originally stored with the fixed structure does not meet the requirement as the goal is to replace a manual process with minimal layout change. All of the columns in the base data are attributes to the Contract Plan ID. Since a Contract Plan ID has roughly 100 attributes, it reads easier if the attributes are listed out in rows instead of columns as there will be at most 10 Contract Plan IDs

         

        Its almost as though I need to apply the slicer prior to transposing the data to get the correct Contract Plan IDs to show however I havent found a way to do this as the slicer is dynamic as well