on 03-19-2018 6:17 PM
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?
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.
Thanks,
Jothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.