Hi all
If I have 2 queries in my report , 1 returns 20 employees and other returns 10 employees (as I have added condition for it to return a smaller data set)
How can I report on the exceptions. ie .Whats in 1st Query (20 Employees) and not in the 2nd Query (10 Employees)
Many thanks
Sims
Create Query 1 as desired
Then add a combined query,
make sure the second query has the same data (object datatype needs to be the same)
change the query type to Minus (double click the join type to change, then again to reach the minus)
The result should be everything in query 1 that does not equal the result of query 2.
Not sure what version you’re on but it has been possible to extend a dimension.
Say =[Emp ID] is your merged dimension that you’d normally use.
Then =[Q1].[Emp ID] and =[Q2].[Emp ID] are your extended dimensions that are based on the original data sets
Add all three to the table and you should see nulls where they don’t appear in both data provider results. Then you can filter based on that to suit your requirement.