How to get last value in grand total space
Hi All,
I need the last value of row in grand total space as per the screenshot.
-
1. Re: How to get last value in grand total space
if min(order date)=max(order date)
then unit price
else null end
-
2. Re: How to get last value in grand total space
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?
-