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:
| 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?
Thanks
stefano
