How to create a simple sum of the values in a column

I apologize this question is so basic...but I am brand new to Looker and cant figure it out.

I have created a Look that provides a snapshot of my inventory, with dollar amounts for each item. There are about 1200 rows of inventory items with costs. All I want to do is for the column with the dollar amounts to provide a sum at the bottom. A simple sum is all I’m looking for. 

1 1 4,428
1 REPLY 1

Hi Jason.

You ask, I comply

Please check which format you will need in your fields:

Looker - Value format name

Review your LookML code , in this case, I am using this measure as example:

5f240d86-cc2b-4189-9762-bdae85918dbc.png

Then, use “total” option in explore:

6be58c7c-fbcc-47a1-ae65-f629286b1026.png
7f292abf-b7c5-4c66-8f0d-4ab429b7d3ff.png

Note: This is a dummy dataset.

Hope this helps!

Best regards,

Leo

Top Labels in this Space