Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    pivot table value and percentage (2003)

    I created a pivot table for products by region for revenue. I added revenue again to the pivot table and converted it to a column percentage. Now for region I have a product revenue and its column percentage directly situated underneath each revenue cell. I would rather have a two cells under each region that is the revenue and its column percentage directly on the right side of its revenue under each region. Can this be done?
    -------------------- east -----------west
    product aaa 75000 75% 50000 50%
    product bbb 25000 25% 50000 50%

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table value and percentage (2003)

    Yes, by dragging the Data button from the row area to the column area.

Posting Permissions

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