Individual Day Wise Data Extraction

[munnawar]

HI Friends,

I have table in which data is storing Day wise , I want to extract these day wise field n create a single Coloumn ,

So that i can relate to my Master Calendar  day wise and Extract Day wise data in my Charts

[pedrobergo]

Hi Munnamwar,

Just join the table WiseDaysTable with the MasterCalendar. You just need load the WiseDateTable using the same Data name field.

Load Data (same field as Master Calendar)

        1 AS WiseData

FROM (...);

So you can use in Set Analysis to exclude the wise days.

SUM({$<WiseData-={1}>} fieldname)

or include these days

SUM({$<WiseData={1}>} fieldname)

[]

Pedro