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).
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.