I've tried several different ways to work this out, and I'm stuck. Hoping for some help.
I have a table containing three Dates that require reporting. Here is my table:
I also have a typical time dimension: Date, Week, Month, Quarter, Year.
My goal is to produce this report (Count of all of these things by Date and Loan Officer):
|Date||Loan Officer||Customers Met||Customers Applied||Customers Approved|
This is eluding me how I would add up all of these. I've tried creating copies of my time dimension table in the physical table. However, this seems to not work every time I add in Loan Officer.
Can someone help me figure out how to structure this in my physical and logical model?