14 Replies Latest reply: Jul 1, 2016 11:23 AM by Sunny Talwar RSS

    How to filter a sum of amount for each field of a particular dimension

    Marco Oberti

      Hello everyone! I have two questions for this community, I hope you can help me

       

      FIRST QUESTION:

       

      I created an app to calculate the sum of the final amount.

      But I need to do it once for each numproduct where nversion is the maximum number.

       

      EX --> i want:

       

      product    | nversion     |  amount      (not considerer - status)

      POL1        20151027      100                                     1

      POL2        20151102       66                                      1

      POL3        20151108       10                                      1+2

       

      TOTAL = 176

       

      how can I do?

      I would like to do in the sheet not being loading data!

       

       

      SECOND QUESTION:

       

      I can show in a table only the results of the distinct?

      I want to use as a dimension only on the results of a distinct product.

      then associate with each dimension his nversion greater. If that nversion has two states, and I want to see only the status corresponding to 1?

        Former: ---> I would like to

       

      product    | nversion     |  amount  | status

      POL1        20151027      100         1

      POL2        20151102       66          1

      POL3        20151108       5            1

       

      TOTAL = 171

       

      I read every forum thread on this topic but I could not find a solution!

      thanks!esempio screenshot.png