Total and Subtotal in Looker Explore

[keerthiks3107]

Hi All,

I have a requirement, where I need to show Yield and in the totals i need to show weighted yield.

Yield	Weighted Yield
4.98	1.4
4.35	2.63
5	2.8
5.84	3.02
4.61	3.56

Output will be something like below

Yield	Weighted Yield	Output
4.98	1.4	4.98
4.35	2.63	4.35
5	2.8	5
5.84	3.02	5.84
20.17	7.05	7.05

I need to show the output column where the rows are pulled from yield and total from weighted yield.

Regards,

Keerthi