I have two datasets where I pull date from for this report...dataset1 has sales by month and location and trans dataset has trans spend by locaiton and supplier.
I want to include sales in a location groups but only sales for that location in the group....right now it seems to sum up all the sales even though I put the sales figure inside the location group...
how do I do that...do I use a iif function?? do I need to do something with parameters?
View Complete Post