9 Replies Latest reply on Apr 19, 2017 11:19 AM by Anthony Abaya

    Aggregate SUM/AVE/TOTAL computation by row given a particular (unsound) table design.

    Anthony Abaya

      Hi Everyone,

       

      Suppose my data source consists of just 1 table with the following fields:

       

      Notice in the SHEET that the table fields were all just put in COLUMNS shelf:

          

       

       

      And in the dashboard, I manually entered TEXTS to correspond to the field columns. If the table design cannot be changed and I want to include a last column for an aggregate value per row, how do I do this?

       

      Table calculations do not seem to work because of the way the data source table was structured. (Notice that the last row is for the ABC placeholders). Anyway I can get this to work? See attached for the TWBX.