1 of 1 people found this helpful
This could be done using Nested Table Calculations.
While the calculations (formulae) are simple,
the Nested part is rather complicated.
Please check the Edit Table Calculation dialog
for every Table Calc pill on a view (filters included).
Please pay a special attention to the Nested part,
because every nested calculation would have
it's own Addressing and Partitioning logic.
Please find the attached.
Hope it could help.