Michael Campoamor
Top achievements
Rank 1
Rank 1
Michael Campoamor
asked on 13 Jul 2011, 03:32 PM
Hi,
Need to be able to "merge" a group into one displayed row (same for a column)...
Example: Records returned with "PrimaryCODE" contains distinct values of A, B, C... K, L, M, N, O, etc...
a, b, c... should group as normal onto its own row
Row "apples" ... PrimaryCode="A"
Row "bananas" ... PrimaryCode="B"
Row ... PrimaryCode="C"
However... I need only one row which will sum, count, avg....etc.... all records that contain the K,L,M,N,O, etc... values
Row "others" ... PrimaryCode="K,L,M,N,O, etc" .... this row would group all OTHER values besided A, B & C
Same for a column...
Example... split out to 6 columns .... that report of one Field X
COL 1 (Field X = "1"), COL 2 (Field X = "2"), COL 3 (Field X = "3"), COL 4(Field X = "4"), COL 5 (Field X = "5"), COL 6 (Field X ≥ "3")
You can see where I need column 6 to group values of 3-5 for Field X
Need to be able to "merge" a group into one displayed row (same for a column)...
Example: Records returned with "PrimaryCODE" contains distinct values of A, B, C... K, L, M, N, O, etc...
a, b, c... should group as normal onto its own row
Row "apples" ... PrimaryCode="A"
Row "bananas" ... PrimaryCode="B"
Row ... PrimaryCode="C"
However... I need only one row which will sum, count, avg....etc.... all records that contain the K,L,M,N,O, etc... values
Row "others" ... PrimaryCode="K,L,M,N,O, etc" .... this row would group all OTHER values besided A, B & C
Same for a column...
Example... split out to 6 columns .... that report of one Field X
COL 1 (Field X = "1"), COL 2 (Field X = "2"), COL 3 (Field X = "3"), COL 4(Field X = "4"), COL 5 (Field X = "5"), COL 6 (Field X ≥ "3")
You can see where I need column 6 to group values of 3-5 for Field X
1 Answer, 1 is accepted
0
Hello Michael Campoamor,
You can achieve your requirement with the crosstab item. The crosstab item supports row and column groups. You have to group by PrimaryCode and limit the group with filters. For the other values you can create primary code's outside group from the crosstab's context menu.
You may find useful the following help article:
All the best,
Peter
the Telerik team
You can achieve your requirement with the crosstab item. The crosstab item supports row and column groups. You have to group by PrimaryCode and limit the group with filters. For the other values you can create primary code's outside group from the crosstab's context menu.
You may find useful the following help article:
All the best,
Peter
the Telerik team
Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!