Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to use the =sum() function on a measure, such as Net sales, but it only works for field values like sales amount. Is there any way I can use it on Net sales?
Again, you can't sum(sum(Field)), so what you're trying to do won't work...
Assuming the measure in question already contains an aggregation, you would not be able to use sum() on it, since you can't directly nest aggregations (e.g. you can't use sum(sum(field))).
You may be able to use aggr() if you need nested aggregation, but without any specifics, I can't begin to guess.
Ok thanks. Would there still be a way to calculate the total of all the net sales in a Table? I would want a whole column with this value and not just the automated total at the end.
What's the difference between "The total of net sales" and "Net sales"?
in the table the net sales are shown for each product and the total are all these added up.
e.g. Total
Apple 1000 3000
Banana 2000 3000
Total 3000
and I don't want it shown at the bottom I want it as another column like I tried to show in my example
Sum(Total FieldName), then.
When I try this, it just says 0 for all. I think the problem here again is that Net Sales is a measure and not a field because when I try with a field value e.g. Sales amount this works
Again, you can't sum(sum(Field)), so what you're trying to do won't work...