I have three fields Qtr Desc(Quarter Description), Date & Created Date.
So, when I pick 2011 Q4 in Qtr Desc it selects a date range 1/2/2011 to 03/28/2011.For the same date range I want all
the items created in this date range.
So how do I do this.
I assume the Created Date is in another table than the Date? Otherwise you should be able to just add the field Created Date to your layout.
If you have a proper connection between the tables it should work just fine. Are you connecting on the Date field?
They are in separate tables. Created date is from the fact table called Opportunity and the Fiscal Year and Qtr Desc are from Time dimension table - Time.
Could you please suggest how can I achieve this?
Thanks & Regards,
This is how my Data Model looks like. I want to connect CREATED_DATE and the Time Table by some way.
Thanks in advance,
Retrieving data ...