Yes CubeGrid is available to Power and Enterprise license holders from Isomorphic. Check out the CubeGrid and Facets classes and take a look at the show cases on the smartgwt pages.
If you are just able to use ListGrid you can achieve the same thing through iterating through the records. If you are able to use a database you can enter customSQL
<operationBinding operationType="fetch" operationId="VEP_AREA_RECORD">
SELECT * FROM (SELECT SUBSTRING(MeasurementTime,7,4) [Year], CASE SUBSTRING(Time,1,2) WHEN '01' THEN 'Jan' WHEN '02' THEN 'Feb' WHEN '03' THEN 'Mar' WHEN '04' THEN 'Apr' WHEN '05' THEN 'May' WHEN '06' THEN 'Jun' WHEN '07' THEN 'Jul' WHEN '08' THEN 'Aug' WHEN '09' THEN 'Sep' WHEN '10' THEN 'Oct' WHEN '11' THEN 'Nov' WHEN '12'THEN 'Dec' END as [Month], [value] , [col1] as col1,
col1 [col1_name], col2 [col2_name], col3 [col3], [col4_name] FROM your_table WHERE MeasurementValue IS NOT NULL) TableDate PIVOT <what you want in rows> FOR [Month] IN (
) AS PivotTable
ORDER BY groupCol1, groupCol2
clearly these columns could be actual values in your records/db or derived (in my case derived from the datefield. I"m not a SQL guru so if there's a better way I'd love to hear it.
In the above exmple the output would be
[jan] [feb] [mar] etc.....in your case
[col1_valA] [col2_val1] valx valy
Hi, We are not using SQL database. Neither we are using Smart GWT EE :-( So we cant implement both of your solutions.