Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I select DATE thru date listbox, it displays correctly. (see image below)
But when I select date thru Year, Month, Day, listboxes.. it displays nothing... (see image below)
Please help. I can't fix for now! I need experts working on dates.
=sum({<Date={"$(=max(Date))"}, Year=, Month=, Day=>} Sales)
you could try this..
have you created them from same source?
Ex Date field:
Year(Date) as Year,
Month(Date) as Month)
Day(month) as Day
Yes, I already have calendar for this.
Hi billiringer,
To get this work out First create the Master Calender table and link it to the base table with the "Date" Field.
Regards,
Nilesh Gangurde
I already have that, check the structure below
but still I have problem which I mentioned above!
=sum({<Date={"$(=max(Date))"}, Year=, Month=, Day=>} Sales)
you could try this..
Thanks renjthpl... Got it!
Got this, this is the answer
Thanks for the help!