+ Reply to Thread
Results 1 to 2 of 2

Show Values As " Sum of over 180 on Nov 1.13 difference from Sum of 001 030 on June 1.13"

  1. #1
    Registered User
    Join Date
    12-24-2013
    Location
    SHANGHAI.PRC
    MS-Off Ver
    Excel 2010
    Posts
    5

    Show Values As " Sum of over 180 on Nov 1.13 difference from Sum of 001 030 on June 1.13"

    I have a question about "Show Values As " in PIVOT, enclosed is the sample

    Simply put ,is there likelyhood I get back the correct value with formula "Sum of over 180 on Nov 1.13 -Sum

    of 001 030 on June 1.13". .

    Thanks you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-24-2013
    Location
    SHANGHAI.PRC
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Show Values As " Sum of over 180 on Nov 1.13 difference from Sum of 001 030 on June 1.

    Thank you ,maitreygk, I found that I made a mistake from the very beginning ,could you

    help on below :

    I want sum up 6 month's AR (by individual),for instance ,in field L21 ,it equals the sum

    of " B6+B9+B12+B15+B18+B21" ,does it workable? THX

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  2. Replies: 0
    Last Post: 01-09-2013, 06:52 PM
  3. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  4. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  5. Replies: 15
    Last Post: 05-01-2007, 04:47 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1