Calculated Totals in table & filter based dynamic calculations

[adityabehera2002]

Hello community,

I have a requirement where i need to show calculated values under a column as a total. Please refer the IMAGE, my calculations are like this: -

1. I get opening column data for each flock and age, i will need only my first age opening column value in each flock, then i will sum it up to get a value A.

2.Now i have a diff column for each age, i need to multiply the diff column value with my opening to get Cal1 values which i will sum to get B.

3.Now i will do A/B to get my data

     but here is my requirement, the diff i will multiply with the opening should change with my age filter, which means the diff column data will be based on what age i choose and accordingly it will get the values multiply and divide to show me the value in total.

Please tell me any workaround

[adityabehera2002]

This is the picture of my model.