14 Replies Latest reply: Apr 23, 2018 6:56 AM by Sunny Talwar RSS

    Aggregation to show a relative percentage to the total

    Wim Steskens

      Hello,

       

      I have a problem with using a aggregation for constructing a relative percentage of the row value tot the total of the rowvalues.

       

      I have uploaded a data file and a qvw file with a exeample to make it clear.
      You will find some dimensions and data columns in the data file.

       

      In the added screenshots of the app is the month apr17 selected.

       

      The problem is that the value of the aggegation expressions is shown only on the total row or on one row of the table that is selected.

      (see screenshot)Screenshot1.JPG

      Clicking on another row makes the aggrgation appear at this row.(see screenshot ).

      Screenshot2.JPG

      Any suggestions ? Thanks for your help in advance.


      Regards


      Wim Steskens