Hi,
I have a problem with grouping/sorting (for lack of a better word) in crosstab.
I want the result with the green header, but I get the result with the red header, please see attached picture.
I know I can get this result by creating a hierarchy and filter it on another key in the fact table, but if the hierarchy is missing and for some reason I'm not having access the the cube, is there a way to get around this in the reporting section and creating the desired crosstab?
Cheers CM