How to refer to Report fields using Grid function.

Mixer

Hi,

I have a report that shows 3 business units from last month. I would like to add bonus to the unit that achieved best results. Is it possible to make max() function based on fields in the report?

Paul Newcome

You cannot use x-sheet references to pull from a report. You would basically have to set up a different sheet with the MAX info on it and add the bonus there.