Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Subtotaling

  1. #1
    Guest

    Default

    I am attempting to provide a listing of year 2001 customer sales totals to my sales force. The row should have the customer name, address, phone, and 2001 sales. Over 15,000 entries and just over 3,000 customers.

    I get to the point where I have everything sorted and subtotaled - but the subtotal appears in a new row and that row doesn't contain the address and phone information.

    Can I move the placement of the subtotal to a line above or copy the address/phone stuff onto the subtotal line (without having to do it one by one) ?


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,424
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    You could create a new column or use a blank
    column and include the relevant text. Heading for this column NDesc

    partial formula =B2&" "&C2 .....

    Use Data Subtotal Sum at change in NDesc

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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