How to collect data totals put in new query with date

[Anonymous]

Dear friend,

i have to report stock every day by putting a new query and refreshing raw data but i want to collect the totals value everyday input with the date in other columns in the new query to show the trend 

thank you

[Anonymous]

Hi @Anonymous ,

Are you want a summarized the table or add a new column to exist table?

Please share some sample data and expected result so we could provide help.

Best Regards,

Jay