Hi

I want to be able to customize column summaries depending on how the user has grouped the data.

Here's an example: I have many columns that the user can group by, and about 40 columns that have summaries on them (these 40 columns are based on time, like weeks, months, etc).

If the user groups by a specific column (lets say Column #1), I want to be able to create different summary types (Sum, Average, Count) based on the group value (based on the value in Column #1).

So if Column #1 had row values like 'Green', 'Blue', 'Orange', I would want the summary types for my summary columns to be:

Green: Sum

Blue: Average

Orange: Count

 Is there any way to do this? If not, do you have any suggestions to try to do something like this?

Thanks