Forum Discussion

ChrsH's avatar
ChrsH
Regular Visitor
8 years ago
Solved

Group subsequently added columns dynamically

Hello,

 

is it possible to group subsequently added columns dynamically?

 

Thanks in advance.

C.

  • Anonymous's avatar
    Anonymous
    8 years ago

    Let's try this:

     

    Go to the Query Editor, select the "static" column(s) (that should be always there no matter what), right click, Unpivot Other Columns.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Please be more specific.

    • ChrsH's avatar
      ChrsH
      Regular Visitor
      8 years ago

      Is it possible to define a groupby routine for all columns, so if one add an column in the data source subsequently, the query still works? I need the same aggregation for every column.

       

      My data source is a SharePoint List,

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi again.

         

        Just trying to figure out what you need, why do you need the sum on another column? Why don't you calculate what you need on the report view?