This content has been marked as final.
Show 3 replies
-
1. Re: How to get last value in grand total space
Amit Narkar Jul 17, 2017 1:36 AM (in response to Tulu Sahoo)if min(order date)=max(order date)
then unit price
else null end
-
2. Re: How to get last value in grand total space
Tulu Sahoo Jul 17, 2017 9:49 PM (in response to Tulu Sahoo)Hi Amit,
It is not giving the correct result. All the months values should keep as it is and only grand total should fill up the last month data. How can I do this?
-
3. Re: How to get last value in grand total space
Tulu Sahoo Jul 17, 2017 11:41 PM (in response to Tulu Sahoo){Fixed year(date):max(date)}=date