Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    47

    Unanswered: %Totals By Groups

    Hello All,
    I've attached a spreadsheet I am having problems with in working out % totals for 2 columns.
    The calculations for each row within the group should be as follws:

    %Turnover = Turnover()/Total Turnover for Group * 100.
    %Profit = Profit()/Total Profit - for group * 100.

    The spreadsheet is dynamic therefore the Total Turnover/Total Profit will almost always be in a different row. However, the columns are fixed.

    I'm hoping someone will be able to revamp the existing code which quite nicely groups the records by Branch and totals up 3 of the columns..

    Kind regards
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2004
    Location
    Poland
    Posts
    6

    Re: %Totals By Groups

    I hope that attached file would be useful...
    During my work I made many samples of code depending on tasks I've been asked so here I am if you want to share our experience :-)

  3. #3
    Join Date
    Apr 2004
    Location
    Poland
    Posts
    6
    I hope that attached file would be useful...
    During my work I made many samples of code depending on tasks I've been asked so here I am if you want to share our experience :-)

  4. #4
    Join Date
    Apr 2004
    Location
    Poland
    Posts
    6
    I hope that attached file would be useful...
    During my work I made many samples of code depending on tasks I've been asked so here I am if you want to share our experience :-)
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •