SSRS Matrix Report Column Hide

[fsugeiger]

Is they a way to hide a column in a matrix report but have it show up in the total or subtotal? I don't want to see HC_Sum but I do want to see the H_Sum.

I want to hide HC_Sum but show H_Sum.

Prod Total
S HC_Sum S H_Sum
32 11 84 28 100.00% 28 100.00%
94 18 100.00% 18 100.00%
64 2 100.00% 2 100.00%

fsugeiger

 

[MDXer]

is hc_sum used in calculating hcsum? if you don't want it in the matrix then don't put it in the matrix.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[fsugeiger]

I wish it was that easy. Yes its part of the H_Sum.

fsugieger

 

[MDXer]

why not create a calculation in your dataset that gives you hsum then you won't need hc_sum in the ds.

what is the calculation for h_sum?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[fsugeiger]

You seem to have all the easy answers to this problem. I already have created another data set and created a cacluated member. The sum or calc is not the issue. Its hiding a column in the report but showing the calc in the subtotal on the right side of the report.

fsugeiger