Forum Discussion
Goals without average
It makes me feel so much better that you said it could be a complex subject! I really thought I was missing one simple date measure. I'll get started with what you have suggested and let you know how it goes. Thank you so much for your help! I do have a calendar table so I'm off to a good start. I have a lot to learn, thanks again!
It can be a little complex, but much easier to break it down into smaller sections and go from there. Just have to put in some time and you'll get it :smileyhappy:
Anonymous , I've replicated all your suggestions except FactSALES. I'm trying to pull in the number of sales from a related table so that it gives me a count of sales by person like a pivot table would in Excel. Then I can duplicate your matrix. However, it is pulling in everyone on the list and I can't determine the best filter to use in order to limit the number of records pulled. I think it should be a date one, but am not certain. See below snippet. Any suggestions? Thanks again for all your help!