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?
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.