After a user groups a column, then chooses columns to display, how can i "regroup" and recalculate accordingly the rows being grouped? something similar to SQL grouping
if you can see in the screenshot, what i want to know is, how to recalculate the rows, (and remove other rows) if my user removes the customer code field distinct to the non-numeric type. (in this view, this is not the only columns, there are 50+ columns, only hidden for this screenshot)
Hi,
I'm sorry, but I do not understand what you are asking.
thanks for the reply .. sorry if this is a little hard to understand,the screenshot was done by the following sql query:select column1, column2, amount, 1 month, 2 month from table group by column1, column2if the user deselects column1 (hide it from the display) i want the display like the way sql query do it ..so it will be like the following queryselect column2, amount, 1 month, 2 month from table group by column2executing this query,the results will be (please refer to screenshot), the first group (12/30/2011) will have 2 rows (since it will be grouped by order type, GA and IS), the second group (12/31/2011) will have 1 row ..i hope this is a bit clearer...