Hide a column in Cross-Tab

[Hyam]

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.

[Alex K.]

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:

Code: Select all

if (e.Value> 100)
e.Value = e.Value / 100;
else
e.Text = "NONE";

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

Code: Select all

e.Value = Cells [-1, 0] / 2;

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:

Code: Select all

e.Cell.SummaryIndex

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.

[Alain25170]

Yes but it' doesn't work !

[HighAley]

Hello,

We see your email with the additional information and will answer there.

Thank you.