June 9, 2017 at 12:54 am
hi
I have a matrix report with Rowgroup = Fields!AssetDescription.Value
ColumnGroup = Fields!Month.Value
Data = CountDistinct(Fields!WorkOrderId.Value)
On my RowGroup I used filter:
Expression = CountDistinct(Fields!WorkOrderId.Value)
Operator = TopN
Value = 10
all of the above works as desired. I added Grand Total after Rowgroup but the total is not correct. instead to totalling the Top 10 it's totalling the entire dataset.
i don't want to use the query to select the top 10 because the data i'm using in other sections of the report.
regards
June 30, 2017 at 12:03 pm
Nomvula - Friday, June 9, 2017 12:54 AMhi
I have a matrix report with Rowgroup = Fields!AssetDescription.Value
ColumnGroup = Fields!Month.Value
Data = CountDistinct(Fields!WorkOrderId.Value)
On my RowGroup I used filter:
Expression = CountDistinct(Fields!WorkOrderId.Value)
Operator = TopN
Value = 10
all of the above works as desired. I added Grand Total after Rowgroup but the total is not correct. instead to totalling the Top 10 it's totalling the entire dataset.
i don't want to use the query to select the top 10 because the data i'm using in other sections of the report.regards
You need to be more specific. I understand what the nature of the problem is, but would need to be able to see exactly how the report is structured, and exactly where the various fields appear. My gut says your Grand Total is going to have to appear within the Rowgroup, but without more detail it's hard to know for sure.
Steve?(aka sgmunson)?:) 🙂 :)?
Health & Nutrition
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply