Hi,
My source is dynamic cubes.
I have a requirement where I have a crosstab with two measures.
I have to filter the two measure against two different dimensions, but display one of the dimensions in the crosstab.
I am able to exclude the member by using except()-function. The member i'm excluding is on level two. The issue is that I need to display level one on the rows, in the cross tab.
I can't use slicer, as only one measure should be filtered by it. To get the except-function to work, I have to use descendants()-function to get the level on the same level as the member i'm excluding - isn't it?
To complicate it further, the exclusion is done on a macroprompt. exclusion works, but i'm not able to display the filtered dimension in the report, for level one, in the hierarchy.
Do you have any suggestions on how to solve it?