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
      A1024
      B524
      C824
      D124

       

      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?

       

      Thanks

      stefano