Forum Discussion
Solved
Grouping by User
I'm using this tutorial with SQL 2014 and AdventureWorks Database I did exactly as it says on the tutorial, but when trying to create the chart, I click the Full Name and it shows a list of names an...
I figured what the problem was, on SalesPersonID, the column had only null values, I was meant to exclude them, but instead I selected all NULLs, so that's why the relationship wasn't working, I have excluded the NULLs and left all others and it's now working as it should.
Thank you all for your time in helping me out on this.
So are you wanting to see sales rep names in your visualisations? I can't tell from the image of the model if the sales rep table is correctly joined to the sales table. I suggest putting salesrep[fullname] on rows and then sales[territory id] beneath it on rows. If the first level is blank but you see all the data at the second level, then your columns are not matching for some reason. Maybe it is the wrong column.