hi,
i have a problem of transforming my ordinary grid display into a custom view. Is there a way to do that, I was thinking of cardview and group by, but i m not sure how to achieve what i want.
refer to attachment, top grid is ordinary view, bottom is the one that i wanted to transform to. please help. thanks
Hi,
It looks like you could do this using RowLayouts. Go into the grid designer and go to the Column Arrangenent Overview for the band. You can choose to use a RowLayout and then design the layout you want for the for.
You might need to add some unbound column for the sub-totals. And depending on what version of the grid you are using you can either use groups or some columns with no cells for the extra headers.
i'm not sure how to do that ? by looking at the excel I attached in the 1st post, it actually transformed data (office) in a row become a new column, and expanding to the right as more rows occurred. So, for ie. i got 6 rows with office1, office2, office3....office6. all those rows data will be transformed into a column and keep expanding to the grid.
Generally, I m doing a Pivot (matrix) table, which is for statistic analysis for column, row and data.
Thanks