Automatic sub totals when printing

Question

Level 1

5 points

Automatic sub totals when printing

Hi everyone,

Tried to find the answer how to get several printed pages with subtotals at the bottom of each sums column, and the reported sum at the top of next sheet.

I first believed it would automatically be managed through the printing process, but the table doesn't react at the page changes.

A she layouts often make of their own depending the printer you use, it could be quite tricky (and time consuming) to fumble around manually…

Does an "automatic" sub-total feature (and it's corresponding sum report) exist in pages and, if yes, can someone teach how to get it done?

Thanks in advance for any help.

Alex

Posted on Jan 25, 2016 7:18 AM

Reply

Answer 1

Jan 25, 2016 7:29 AM in response to almux

You should review the printing guidelines Ian has created:

Print Layout Guide for Numbers 3 on Mac

Numbers does not have stellar printing capability.

It would help me if you posted some example data from what you have right now.

Reply

Answer 2

almux Author

Level 1

5 points

Jan 25, 2016 7:39 AM in response to Wayne Contello

Thank You Wayne for this prompt answering.

As, here, we're close to shutting office, i'll take a look tomorrow and tell thereafter.

BR

Alex

Reply

Answer 3

almux Author

Level 1

5 points

Feb 1, 2016 11:36 PM in response to Wayne Contello

Hi Wayne,

I sub-divided the document manually into three tables and reported each sum on first line of next page.

It's OK, though it would be nice to find a "Next page sub-total" in one of the future update of Numbers… 😉

Reply

Answer 4

Yellowbox

Level 7

20,389 points

Feb 2, 2016 2:21 AM in response to almux

Hi almux,

Are you trying to create a Cash Book with subtotals on each printed page?

You can do this in Numbers.

Start with this:

The blue lines are Layout Guides to show the top and left page margins. They do not print.

Arrange (delete rows and resize) the 'Starting Balance 2015' and 'Cash Book Page 1' to fit on one sheet of paper when printed.

As Wayne said, see Print Layout Guide for Numbers 3 on Mac

Scrolling down (with Freeze Header Rows)

Formula in E31 of 'Cash Book Page 1'

=E30

For Carried Forward (to the next page) Formula in Footer Row E31 =E30

Copy and Paste the 'Starting Balance 2015' table and rename it as 'Brought forward'

Now select the table 'Cash Book Page 1' and Copy and Paste. Rename it is Cash Book Page 2

Arrange them (Drag) on the canvas

Continue as many times as you need (paper) pages.

Now make use of the Sheets in Numbers.

Insert a new Sheet, and delete the default table.

Select the tables you want from Sheet 1, Cut and Paste on the new Sheet.

Menu > File Print > Print all Sheets

Click on Print for a Print Dialogue.

If that is not satisfactory, click on Done to return to your document.

Delete some rows that may have flowed over (unwanted) to the next Sheet.

A bit fiddly, but once you get it to work, Save as Template for future use.

Regards,

Ian.

Reply

Answer 5

Yellowbox

Level 7

20,389 points

Feb 11, 2016 12:27 AM in response to Yellowbox

Added comment (I was too late to edit my post)

Instead of Cutting and Pasting from Sheet 1 to Sheet 2, use the Contextual Menu in the Sheet Tab to Duplicate Sheet 1 after you are satisfied with the Page Layout.

Then the tables will be in the same place on the new Sheet (page). Edit the table names and formulas.

Happy Numbering!

Regards,

Ian.

Reply

Answer 6

almux Author

Level 1

5 points

Feb 3, 2016 10:42 PM in response to Yellowbox

Oh!

Great, thanks for your precise answer!

I never used any of these tables solutions before (Exel, etc.) and the page settings are quite different with Indesign… For example: I still couldn't find out how to change the tabulation in a column in order to change the positioning of the sums aligned on the decimal separator… while such an easy thing to do with Indesign. I have to get it with another logique, I guess… 😉

BR

Alex

Reply

Answer 7

almux Author

Level 1

5 points

Feb 11, 2016 12:29 AM in response to Yellowbox

Tried it out and… YES! This works real good and was exactly THE thing!

THANKS!

Reply

Answer 8

Yellowbox

Level 7

20,389 points

Feb 11, 2016 1:49 AM in response to almux

Hi almux,

Glad it worked! Thanks for the gold star and your feedback.

Regards,

Ian

Reply

Answer 9

almux Author

Level 1

5 points

Jun 4, 2016 8:40 AM in response to Yellowbox

Hello Yellowbox,

So sorry… but I tried to have sums and forwards on another document and… I'm absolutely unable to reproduce the functionality!

(I must be especially dummy, I guess!)

It's all on two pages but only one table. At the actual final line, I got the sums of wins and losses, each down their respective column. Now, not only I can't get the subtotals at each page bottom, but i also would like to get the final gain/loss calculation in a new line beneath.

Could You find a little time for helping me out of this contrariety?

Thanks, anyway for Your attention.

Alex

Reply

Answer 10

Yellowbox

Level 7

20,389 points

Jun 4, 2016 9:51 AM in response to almux

Hi Alex,

I am thinking about this. Numbers 3 is not good at Page Layout.

I do not see a way to automatically insert sub-totals at the end of each page. I think that it must be done manually.

The black rectangle shows the maximum printable area within a page.

The orange Guide Lines are a suggestion where to stop and insert a new table (allow some leeway).

A new table on another Sheet (Print all Sheets) may be the way to solve this.

Still thinking...

Regards,

Ian.

Reply

Answer 11

almux Author

Level 1

5 points

Jun 4, 2016 11:05 AM in response to Yellowbox

Hello,

Nice to try helping anyway! 😉

I also have to confess that I'm still on v2.3 because most of my important apps do not run under OSX 1.9. 😊

Well, I got the other document, the last one (following your tips few earlier posts) that went well… Also another thing that would be clever, from Apple's part, is to explain the functions… and not only list these cabalistic groups of police characters! That would pretty help too, I think…

In the meanwhile, You think creating one layout as functioning summing page and just copy/past the sums on first line of the next, aso, on as many copies as needed is the swiftest way, at the moment?

It ain't that hard to do those operatioons by hand, of course… But, I thought Apple would like to seriously enter into busynesses… 😮

Wonder if You'll find some smart trick them next. Would be great, of course.

B.R.

Alex

Reply