Hi All,
Is it possible to have a column in an UltraGrid that has a formula applied to it which instead of working off each row in the grid, works like a summary instead?
Here's an example in Excel:
So if we had a function that could tak a column that the data is grouped by ('Product Type') and a column specifying the values to aggregate on ('Price'), we could create the 'Total Product Type Price' Formula Column writing a formula along th elines of the following:
sumbygroup( [Price], [Product Type])
However, if we tried to use that formula in a column, the values would simply be the corresponding 'Price' value for that row (simply the 'Price' column repeated).
Is this possible?
Cheers,
Richard
Oh... another option you might want to consider is to just add a Summary for the Price Column and then use OutlookGroupBy to group the data by Product Type.
Hi Mike,
Thanks for the prompt suggestions!
I had thought of making use of summaries and the outlook group-by functionality, but the problem is we want to allow the user to evaluate the result AS IF they had grouped by a particular column.
I'll look for an alternative way of doing things.