1. TARGIT Community
  2. Community
  3. General Discussion
Knowledge Base

Calculation: How to get value from first user dimension member

Thomas Ejlerskov ·

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

2 comments
Sort by DateVotes
  • Marlene Knaup

    Hi Thomas, 

    I created an example that might help:

     

    The d1(s) inside the calculation uses the first value (d1) of each sibling (s).

    1
  • Thomas Ejlerskov

    Thanks Marlene. That worked like a charm! :-)

    /Thomas

    0
Please sign in to leave a comment.