Hi there,
I received some amazing help on a related challenge, which you can find here - Struggling with a simple counting in a table
In addition to the request to count/add items on a weekly basis, i would also like to count based on 2 other variables.
In the example below I would like to sum the duration by week for the category and category+type.
As new weeks are added to the table, we would need to add a new row to the sum tables.
Any help would be much appreciated.
Andy
I just added to your doc a view, grouping by week, category and type. With the summarize function you can sum the duration of all the items within one group, so by collapsing/expanding them you can see the duration of specific categories/types.
Does this help you?
1 Like
this goes a long way to solving one problem, there is another, where I would like to put the totals into a seperate table.
What is the best way to approach this?
You will need to be a bit more specific. The totals of what? Which table?