asked on March 3, 2022
Hi,
We have a table below which we have created additional rows to show 3 year, 5 year and 10 year average values. These values are generated assuming all the filters of the table have been enabled to 'All'.
I would like to know a recommended solution for us to calculate the average values on selection of filters so we can update our averages rows accordingly.
Attached couple of screenshots for reference. 1st screenshot is with all filters enabled, 2 nd screenshot is with one filter applied.
Warm Regards,
Akshay
⋅ March 3, 2022
Attaching 2nd screenshot
⋅ March 4, 2022
Hello, Akshay,
Thank you for contacting us.
We would like to recommend the similar approach as we described in the following answer: https://www.flexmonster.com/question/pin-grand-totals-to-the-top/#answer-44545
Please note that it is important to correctly define custom filters in the slice in the getData parameters for every row - 3 years, 5 years, and 10 years.
We hope it helps. You are welcome to write to us in case further questions arise.
Kind regards,
Nadia
