Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In a sales application how do i find the maximum of the sales and the minmum of the sales in a year.
Please find the attached...
Regards
Chriss
Are you looking for Min/Max Amount per year? Try this:
=Min({$<Year={'2012'}>} Amount)
=Max({$<Year={'2012'}>} Amount)