Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.apps > #20783

Re: Numbers problem

Show all headers | View raw

In article <1lg6epu.oce112sy723kN%dempson@actrix.gen.nz>, David Empson
<dempson@actrix.gen.nz> wrote:

> > One workaround that I just now thought of is to have a different sheet
> > for each month, and put the summaries, via a "sum" function on sheet 1.
> 
> Sure, there are options to do it with structure or calculations, but it
> isn't as nice as the categorize feature.

Of course.  AsI said, it's nice to have but not necessary.

The column headings are

Date  Black  Silver  Red  Gold  Platinum.

I have a second table that has the same headings plus "total"
The first row under the headings contains the sums of each of the
corresponding rows in the first table.  Total, of course, totals the
rest of the row.

The second row contains the percentages of the total for each color.

And for the heck of it, there's a pie chart showing each of the colors
(currently except for platinum because that column is still blank).

Back to comp.sys.mac.apps | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Numbers problem Michelle Steiner <michelle@michelle.org> - 2014-01-26 16:44 -0700
  Re: Numbers problem dempson@actrix.gen.nz (David Empson) - 2014-01-28 02:08 +1300
    Re: Numbers problem Michelle Steiner <michelle@michelle.org> - 2014-01-27 09:02 -0700
      Re: Numbers problem dempson@actrix.gen.nz (David Empson) - 2014-01-28 13:38 +1300
        Re: Numbers problem Michelle Steiner <michelle@michelle.org> - 2014-01-27 23:46 -0700
          Re: Numbers problem Paul Sture <nospam@sture.ch> - 2014-01-31 10:00 +0100
        Re: Numbers problem Michelle Steiner <michelle@michelle.org> - 2014-01-27 23:51 -0700

csiph-web