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:
item
quantity
total quantity
A
10
24
B
5
24
C
8
24
D
1
24
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?