I have tried to make a filter which effectively should have made me get one figure for one group.
As per the enclosed pictures I had a table of sales grouped per user group. When I chose 'User's primary group' as the organization filter I expected to see only one group, but I see two. How is that explained?
Stein
Hi Stein Ove,
I'm not sure. If you can send me or post a copy of the SQL statement that was generated, I think I can give You an accurate answer. Use SQL Server Profiler to get hold of the SQL statement.
-Erik
(erik at businessanalyze.no)