subtotal and subaverage

The best you can do at this time with a matrix is hide the unwanted AVG header and associated cell. You can do this by setting the Visibilty property of the AVG header and cell to an expression that checks the current scope against that of the parent dynamic group. In this case the parent dynamic group is the Month column group. Subtotals do not have the same parent dynamic group as the normal associated cells. In this case the subtotals are not scoped within the Month column group, like the AVG header and cell, but within the Quarter column group).
Here is the exression to use, make sure the change the string to the actual name of the appropriate column grouping.

=InScope("Month_Column_Group_Name")

Ian

You can set the width of the MatrixColumn to 0.

Hi djmdzq9,

I Have the same problem now.

Do you have a solution that width of the average-column is not 0?

Thanks.

What you may be able to do instead is to use only one cell for the data and one for the header. Each cell contains a rectangle that contains two textboxes, one for the subtotal and one for the subaverage. And instead of hiding the header and associated cell, just hide the subaverage textboxes in the rectangles, using the InScope() function, as before.

Ian