Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Adding calculated values to table pre-filled with values

Hi, I want to create the below table where in i have some prefilled dtaa present. On this data I then want to add daily calculated values from other table using formulas please assist me how i can do...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Greg for the valuable input.  🙂  May be I did not state my problem clearly though:

 

I do not want to add columns to my existing Raw Data extract. I create the Matrix table of using data points from the Raw data sheet and now instead of manually entering data everyday i want to calculate the data in each row daily from my raw data extract taken the next day for ex: tomorrow i.e. 10-Apr when i upload my Raw data, the Table with row for 9th April will auto update for Incoming, End of Day & Handled data

 

Please help how i can define/caculate values and update the table daily for previous day data

 

Thanks a ton


Kind Regards,

Tushar