Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to develop below dashboard based on the below conditions.
I have to get total by month.
e.g. 2013 selected, totals should be DEC & 2013, Nov2013,oct 2013, sept2013.
3. If Year only selected and that is Current year default to Current month & current year and so on.
e.g. 2014 selected, show Sept 2014, aug 2014, july 2014, june 2014.
4. If Year, Month selected – show as selected in boxes.
5. If Day only selected, show the current month and current year and so on.
6. If month only selected, show current year and current month and so on.
7. if Quarter selected and no year selected, show that quarter months and current year
8. if year and Quarter selected – show those months.
You could read the selections with getfieldselections(), getselectedcount() and so on and use these values for your calculations, for example:
if(getfieldselections(Year) = year(today()), THEN, ELSE)
if(rangesum(getselectedcount(Year), getselectedcount(Month), getselectedcount(Day)) < 1, THEN, ELSE)
But I think 8 different levels are too much, it will be (too) difficult for a user to find out which selection leads to which calculation.
- Marcus
Hi Anyone,
used this before?
Thanks,
Lakshmi