ssrs 2008 - Getting Overall row total in column total -
I have a matrix and I have to get the total line so that I can do one percent.
This is a thick matrix layout
[MyDataSet]
[MyParentGroupRow]
[ColumnA] [ColumnB] [ColumnC ] [Column Total X] / [Total Rows Total]
Total [column total] [column total c] - [total rows total]
I am unable to get [overall the total line value]. If I use a root dataset then it will be wrong because Tablix has been filtered. That's why I need to get total rows for [MyParentGroupRow].
Notes I can not change the dataset, everything is counting rows, so I can not use things like yoga.
Comments
Post a Comment