Need sum Of Value

working on calculating Total sales per day,

I have two column in table to calculate total sales per day based on total shipped that day.
if Total Shipped = 1 and date = today's date.
I need sum of
total dollar value

Any Help Appreciated

Use an aggregate filter.

You could create a table visualization, use the filter to get only the products with Total Shipped = 1, and the options for the visualization to get the Total value at the end of the table, otherwise you could use the sum aggregation.

Thanks Iker, Using filter i can get the values.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.