Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tech2
Yak Posting Veteran
51 Posts |
 Posted - 2015-03-04 : 14:15:21
|
| How would you Filter a Column Group Matrix? Over 100 locations.The Matrix includes two columns - Column 1 is the field value and Column 2 is the count of Column 1.I want to filter the count to > 5 for the first matrix and add another matrix below for the next group.I tried using =Count(Fields!WRHS.Value) in the Tablix Properties, but I get an error - 'Aggregate functions cannot be used in dataset filters or data region filters'.Expression =Count(Fields!WRHS.Value)Type Integer (I also tried text)Operator >Value 5Thanks |
|
|
|
|
|
Filter Column Group Matrix