Sum total value by week month and year

[Mouldi_Zeghouan]

Hi,
I have a table (Jobs) with columns:
ID,customer name,Timestamps,Net weight received.
My question is how I get total net weight received by Week,Month and Year?
Please advise.
Thanks

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I do SUMIF() or SUMIFS()? SUM( SELECT( Orders[Total Amount], AND( ([Customer] = [_THISROW].[Customer]), ([Order Date] >= [_THISROW].[Order Date]) ) ) ) Use SELECT() to gather values from a single column only. See also: AND(), SUM()

[Mouldi_Zeghouan]

Hi,
Thank you for your reply, I used SUMIF google formula to populate the Year and the total net weight by year on G sheet.
Please see below.

My request is how to view year and total net weight by year in my app?
Thanks