
As you can see, you can only select dimensions from the filtering section. Also there is no option for sorting. Heres how you can do it:
FILTERING:
There are two options. One from the query editor. Other from the tablix properties. I prefer the tablix properties (since sorting MUST be defined there and I found no other way to do it). I explain the first option here and the second option along with sorting.
- Filtering using query properties:


All set. The procedure for setting the filter in tablix (your table) properties is presented next along with sorting :)
SORTING :
Select tablix properties:


I would prefer the query to do this for me (to save SSRS resources and utilize SSAS resources) but I did not find that option (as of SSRS2008).
Enjoy!
No comments:
Post a Comment