Skip navigation

How can I create a report from a spread sheet?

303 Views 5 Replies Latest reply: Jan 2, 2013 12:50 AM by Yellowbox RSS
diane41 Level 1 Level 1 (0 points)
Currently Being Moderated
Dec 30, 2012 2:14 PM

I have an inventory spread sheet.  I want to create a report listing unsold inventory.  Trying to set a rule to show only items with no figure under sales amount column.  Help.

MacBook Pro, Mac OS X (10.6.7)
  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Dec 31, 2012 5:31 AM (in response to diane41)

    Hi Diane,

    Copy part of your inventory spreadsheet (with sensitive data removed) into a reply so that people on this forum can see what you are trying to do. Then we can see what you mean by "items with no figure under sales amount column".

     

    Perhaps "no figure" means a zero? Do you want to highlight those items that have not sold?

     

    The more information you can give, the easier it will be for forum members to help you.

     

    Ian.

  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Dec 31, 2012 9:39 AM (in response to diane41)

    Diane,

     

    You can use the Reorganize Panel to Show Only Rows that have a value greater than zero in the Sales Amount column. You can easily turn this feature on and off, so it doesn't permanently affect your table.

     

    Jerry

  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Jan 1, 2013 10:12 PM (in response to diane41)

    Diane,

    In the column to the right of the data (it looks like Column G) enter =SUM(D3:F3) and fill down. Your table may be wider than the one you showed, so just make the rightmost column to sum all sales for each item.

     

    Then sort entire table by the Totals column.

     

    Ian.

  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Jan 2, 2013 12:50 AM (in response to Yellowbox)

    Oops,

    Got the row numbers wrong. Your data start at Row 2, so make G2=SUM(D2:F2) then fill down.

    Ian.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.