Hi,
I have a cube with two dimensions, case and time and a single meaure
the requirement that I have is to provide time and case on Columns with Measures on Rows in the Form or a bar chart. My client would also like to compare the value of of each member of case with the average of all members case.
Is there a way to create a calculated member that will not aggregate or be sliced by the case dimension, so that the value of the average will always be the same for each member of the case dimension.
I am sure there is a simple way to do this, but I cannot find it.
Thanks,
Rich