Skip to Content
avatar image
Former Member

How do I get just the first second and third values for a dimension for a record?

I have a dimension and I just want to show the first couple of values for it. For example

Student ID Restriction Name

1 FAH John Smith

1 BOH John Smith

1 ABC John Smith

2 BOH George Davis

2 ABC George Davis

I want to have it so each student is only on one line, so I want to show the first three restrictions in one line...

Student ID Restriction1 Restriciton2 Restiction3 Name

1 FAH BOH ABC John Smith

2 BOH ABC George Davis

What is the bast way to do this?

Add comment
10|10000 characters needed characters exceeded

  • Hi Amit,

    I guess the person who posted question actually has to consider a comment as an answer.

    Was it any different now??.



  • No your understanding is wrong.

    Check below.

    Leave Comments and provide Answers, note the difference

    In our new Questions & Answers platform there are two ways you can help other community members with their questions: by leaving Comments and providing Answers.

    So what's the difference?

    You should leave comments when you think the poster should clarify a question, provide more information, or post images that might illustrate the problem. The purpose of comments is to coach the poster so that you and other community members can better understand the question and offer the best possible answer. Speaking of which...

    You should leave an answer that you believe provides a solution to the poster's problem. The poster, in turn, should mark your answer as correct (if it is correct) or share additional details to explain why the question hasn't been answered yet. Once a question is marked as answered, it becomes a resource that can help other members who search the community later for a solution to the same problem. As a result, it reduces the number of redundant questions.

    Using comments and answers together with well written/descriptive questions will enable us to create a high-quality knowledge base that will enrich and serve our community members.

  • Gotcha!.

    Thanks Amit.

  • Get RSS Feed

1 Answer

  • Mar 20, 2018 at 04:22 PM

    Hi ,

    Try these variables.

    1. [Rest] =Last([Restriction) In ([Std Name])

    2. [Concat Rest] =If(Not(IsNull(Previous(Self;([Std Name]))));Previous(Self;([Std Name])) + ", ") + [Restriction]

    3. [Rest Concat] = =[Concat Rest] Where ([Restriction] = [Rest]); this would be Detail associated dimension is "Restriction".

    Drag and drop 3rd variable into table.



    Add comment
    10|10000 characters needed characters exceeded