on 01-05-2015 8:19 PM
Let's say I have a 2 dimensions that are numeric. To get the text value for each numeric value I have join with another table.
What do I do to get those values in the report?
Can someone let me know if this is the right approach? I added a dimension variable with the following formula:
=[Fname] + " " + [Name] ForEach([Sent To]) In Report
That only works on the ones that have distinct [Sent To] values. On the ones that don't I get #MULTIVALUE
What am I doing wrong?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
#DATASYNC means that some dimension is not merged. How many queries do you have ? Which object comes from which query. I´ll post a screen shot of what I mean by creating a detail variable.
Try concatenating FNAME and NAME , like [full name]= [FNAME]+[NAME] and create a detail variable on [full name].
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.