SSRS - Problem with sorting
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I'm facing a real challenge in a report I've built with MDX in SSRS. I have "Keywords" (Dim) column, and "Cost" (Measure) column. There are a lot of the same keywords (each from different Campaign, which name I preset in the KW tool tip). I need to make sure that all KWs from the same kind will display one after the other. The problem is, I need to make sure it's stays in that order even when sorting (interactively) the "Cost" column. basically, the sorting will start again after each group of keywords. And I must display each one of the KWs, not grouping them to 1. Is it possible? what is the best solution? Thanks!