I am blocked on my last step with something that seems so simple, but I am probably missing a step somewhere
For a food tracker, I compute the food the user eat everyday in a tab, https://prnt.sc/rzkx5m
and then in another tab I want to show the results show showing the results of what you ate in a specific day. (Cal / proteins / fat etc)
I discovered to make a sum with the Roll up column option, but the problem is that it displays for the entire column (see screenshot) - https://prnt.sc/rzkt17
So now, I have the same sum for everyday of my calendar, versus for one specific day.
I would like the Sum to be saved on each rows, as they are days of the week. (Calendar view)
This way each days will have different sums, because the user eat different foods everyday.
Any ideas which steps should I do to make it possible?