One selection selects multiple fields

[prasadmundewadi]

I have Opportunity data as shown. Each opportunity has a closed date and a created date. Also a day of quarter.

Oppty          Created Dt          Closed Dt          Created Day of Qtr          Closed Day of Qtr

111               1/1/17                 31/1/17               1                                        31

222               1/31/17               2/15/17               31                                     46

333               1/25/17               1/31/17               25                                     31

444               2/2/17                  2/20/17              33                                     51

User wants to make 1 selection on a 'Day of Quarter' e.g. 31 and that should give him the 1st 3 rows above.

Is there a way to achieve this?

[sunny_talwar]

Is created and closed day of qtr created in script or are they expressions?

[prasadmundewadi]

They are readily available in the source table.

[sunny_talwar · Accepted solution]

May be create a link table

Fact:

LOAD Oppty,

     Created Dt,

     Closed Dt,

     Created Day of Qtr,

     Closed Day of Qtr

FROM ....

LinkTable:

LOAD Oppty,

     Created Day of Qtr as Day of Qtr,

     'Created' as Flag

Resident Fact;

Concatenate (LinkTable)

LOAD Oppty,

     Closed Day of Qtr as Day of Qtr,

     'Closed' as Flag

Resident Fact;

And now select in Day of Qtr field