Surpressing row, column and total sums in a grid
Hi
I got a query result with 3 fields and about 50000 records.
Now, I want to pivot the data set depending on the values
present in field #1 and field #2. Simple job, I did this before
using the PivotCube component.
Everything is nice, but ON DEFAULT the grid has one additional
column and row (SUMs or AVGs). A right-click on the fields (*)
within the grid opens a local menu allowing to enable or
to disable "sums" as a additional column or row within the grid.
How to setup the grid options showing NO row sums and NO column sums
as a default.
Is there any documentation I missed ?
SanX a lot, MZ
(*) added by: AddFieldTo(...)
I got a query result with 3 fields and about 50000 records.
Now, I want to pivot the data set depending on the values
present in field #1 and field #2. Simple job, I did this before
using the PivotCube component.
Everything is nice, but ON DEFAULT the grid has one additional
column and row (SUMs or AVGs). A right-click on the fields (*)
within the grid opens a local menu allowing to enable or
to disable "sums" as a additional column or row within the grid.
How to setup the grid options showing NO row sums and NO column sums
as a default.
Is there any documentation I missed ?
SanX a lot, MZ
(*) added by: AddFieldTo(...)
Comments
What you see is a total column which you can turn on/off by a popup menu on dimension. You can also hide totals by the next code: