Calculation: How to get value from first user dimension member
I have a simple crosstab with one dimension ("ItemGroup") and one measure ("Value"). In the crosstab i have added a user dimension ("Period") which has five members).
How do i make a calculated column that shows the the value of the first user dimension member for each item group? The desired result can be seen in the added picture (red font).
Thanks :-)
0
Comments
Hi Thomas,
I created an example that might help:
The d1(s) inside the calculation uses the first value (d1) of each sibling (s).
Thanks Marlene. That worked like a charm! :-)
/Thomas
Please sign in to leave a comment.