Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Here's the sample Data:
Creation Date | PDC Date | Customer Name | Amount | Status |
---|---|---|---|---|
8/1/2012 | 8/7/2012 | Adrian Luke | 78,000 | Active |
8/2/2012 | 8/6/2012 | Jesiel Jacob | 64,768 | Active |
8/3/2012 | 8/5/2012 | Jesse McArthur | 89,899 | Active |
8/5/2012 | 9/1/2012 | Sharon Concepcion | 34,900 | Close |
8/6/2012 | 9/5/2012 | Martin Michael | 67,234 | Active |
Say, I choose data 8/5/2012. It should display, PDC Date greater than the chosen date and Creation date is equal or less than the chosen date.
Thanks,
Bill
Hi Billringer,
try below expression:
Sum({<PDC Date = {">$(=Max(PDC Date))"},Creation Date = {"<=$(=Max(PDC Date))"}>} Amount)
Add Customer Name in Dimension
Regards,
Nilesh Gangurde
Hi Nilesh.
Can u give me example? It's not working in my part! Thanks,b
Hi Brillinger
u can use following expression
Sum({<PDC_Date={">$(=Max(PDC_Date))"},CreationDate={"<=$(=Max(PDC_Date))"}>} Amount)
Regards
Pradip Sen
Please attach the sample Data..
Regards,
Nilesh Gangurde
Hi
It would help if you could be more specific about how you want to use the epxression. Is it in a straight or pivot table? What dimensions are there? Or do you want to show this in a list box?
Also, please try and be more specific about how it is not working. Is it returning nulls, or is it returning everything (ie filter not working) etc
Regards
Jonathan
Thanks. I just got it!
GUYS, I got problem..
When I select date: 8/14/2012
It is different to
Month: Aug
Day: 14
Year: 2012
How to do that in set analysis?
I GUESS, I should separate Year, Month, Day --- what do you think?
Hi billiringer,
Make Master calender with the Year, Month,Day and use the above expression for the same to have data according to selections.
Regards,
Nilesh Gangurde
I already have master calendar, check the problem on this link. Thanks please.