Sum for table calculations

[Orbach]

I have a table calculation for my “net” column where each row has items of a specific value.

Normally, the total for that column is the calculation performed on the totals row, whereas what I want is a summation of the column.

Illustration:

	cost	item value	number of items	net
1	200	50	2	-100
2	200	300	3	700
total	400	120 (default item value)	5	?

As it stands, the ? will be 200 (120*5-400). I want to see 600 (-100 + 700).

[masutaka]

In a table calculation, totals are always calculated horizontally.

If you create a LookML view that aggregates this view using derived_table, it may be able to achieve this in a pseudo-realistic manner.