Generic Date Object for Drill

[Anonymous]

I have one table which has the segment, funded_date, lost_date, new_date & amount. I want to display a simple table which has columns Segment, sum of funded amount, sum of lost amount & sum of new amount. The List box above should just display list of valid year and upon the click of a particular value, the values in all columns of table should change. How do I create this list box of date when this date needs to be associated to all the above dates?

Thanks,

Dinesh.

[#2]

Can you send the application example?

[Anonymous]

I cannot send the application due to privacy concerns.

If you can point me in the right direction, I could take it from there.

Thanks,

Dinesh.

[#4]

It can be something like this:

Data:
Load Segment, Date, DateType, Amount;
SQL Select ....;
Calendar:
load fieldvalue(Date, iterno()) as Date
autogenerate 1
while len(fieldvalue(Date, iterno()));
left join (Calendar)
load Date, year(Date) as year, month(Date) as Month, day(Date) as Day
resident Calendar;

Your chart may have:

- as Dimensions: Segment and DateType

- as Expression: sum(Amount)

In the list box you can have the Calendar filelds.

[Anonymous]

How can create LOAD statement like you mentioned from the below SQL statement?

SQL select segment, funded_date, lost_date, new_date, amount;