Hello,
Is there any way to group two different summary methods(sum and average) in a unique column "TOTAL" into a cross-tab, without appearing "sum" and "avg" for every item? I'm using conditions to hide the second column, but the first one doesn't fill the month column. Like the attached image.
Thanks in advance.
Hide a column in Cross-Tab
Re: Hide a column in Cross-Tab
Hello,
Unfortunately, it is not possible for the Cross-Tab component.
As a way, you can use the ProcessCellEvent event.
The event allows you to process the value of cells after the rendering a cross-table. An example of the event for cell summation:
In this event, you can also apply to other cells. Example:
Cells [0, 0] - a numeric value in the current cell
Cells [-1, 0] - a numeric value in the cell on the left of the current one
Cells [1, 0] - a numeric value in the cell on the right of the current one
Cells [0, -1] - a numeric value in the cell above from the current one
Cells [0, 1] - a numeric value in the cell below from the current one
To subscribe to this event for changing the totals, it is not necessary to subscribe to the cell summation but to the total cell (the Total inscription). In this case, additionally, you can use the following variables:
is the total index, starts with 0. For example, if using two total cells in the cross-table, the first one will have the 0 index, the second one will have the 1 index. If the cell does not have an index (is not a total), then the index is -1.
e.Cell.IsCrossSummary is the total angular cell, the cell at the intersection of horizontal and vertical lines of totals.
Thank you.
Unfortunately, it is not possible for the Cross-Tab component.
As a way, you can use the ProcessCellEvent event.
The event allows you to process the value of cells after the rendering a cross-table. An example of the event for cell summation:
Code: Select all
if (e.Value> 100)
e.Value = e.Value / 100;
else
e.Text = "NONE";
Cells [0, 0] - a numeric value in the current cell
Cells [-1, 0] - a numeric value in the cell on the left of the current one
Cells [1, 0] - a numeric value in the cell on the right of the current one
Cells [0, -1] - a numeric value in the cell above from the current one
Cells [0, 1] - a numeric value in the cell below from the current one
Code: Select all
e.Value = Cells [-1, 0] / 2;
Code: Select all
e.Cell.SummaryIndex
e.Cell.IsCrossSummary is the total angular cell, the cell at the intersection of horizontal and vertical lines of totals.
Thank you.
-
- Posts: 4
- Joined: Thu Feb 04, 2021 9:40 pm
Re: Hide a column in Cross-Tab
Yes but it' doesn't work !
Re: Hide a column in Cross-Tab
Hello,
We see your email with the additional information and will answer there.
Thank you.
We see your email with the additional information and will answer there.
Thank you.