I have a dataset with prices on a dozen different products that need to be grouped by country and analyzed for mean, median, mode, count and range (max/min) in order to establish a pricing model. New data will regularly be added to the underlying dataset.
All of these functions could be setup in the base sheet's Sheet Summary but since there are 5 or 6 analyses for dozens of countries this would require manual input of a couple hundred formulas. The result would also be difficult to navigate although a linked report or dashboard would make it more user friendly.
A report allows grouping and has built in summaries including average, maximum, minimum and count but it can only run one of those per column (prices) at a time and also lacks some of the needed functions.
Maybe there is a better way of setting up via a dashboard? It would be great to have dropdowns that the user can select criteria from such as specific country/s, or specific numerical parameters (means above X).
I would appreciate advice or recommendations on how to best setup and execute.