Hi All,
just wondering if it is possible for the Grand Total on the Row to equal the highest Cell value on that row.
please see attached spreadsheet.
Thanks
Steph
Hi All,
just wondering if it is possible for the Grand Total on the Row to equal the highest Cell value on that row.
please see attached spreadsheet.
Thanks
Steph
if you only have one entry per seller per day then change the field function from sum to max. if you have more than one you'll need a formula outside the table
Josie
if at first you don't succeed try doing it the way your wife told you to
Right click on the Grand Totals > Summarize Values by > Max > ok
Thanks all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks