0 Replies Latest reply: Jul 29, 2015 5:57 AM by stefano minella RSS

    Set Analysis on total value

      Hi all,

      I loaded sales by item (two columns: item and quantity) and create a table with these two values.

      Now I would like to calculate the total quantity as the sum of all the item quantities , and add this value as third column in the table (so these column should contain always the same value, because it is a total).

      This is what I would like to have:

      itemquantitytotal quantity


      I tried to create a new measure but when I add it to the table the value is always related to the item, it's not the total. I tried with this code but it doesn't work:

      sum( { < item_id = { "*" } > }  invoiced_qty)


      How could I change the measure in order to have the total value?