+ Reply to Thread
Results 1 to 10 of 10

Grand Total Query

  1. 05-08-2015, 04:50 AM #1
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Grand Total Query

    Hi,

    I am new to pivot tables and have a quick question.

    I have a set of data that is supplied by two different people. At them moment I got a grand total that comes up totaling the two sets of data.

    What I am after is to have toe two sets of data visible along with the variance between the two.

    I have worked out how to find the variance but I then lose the original quantities.

    Is there a way around this?

    Pivot Query.pdf

    Thanks for your help in advance.
    Reply With QuoteRegister To Reply
  2. 05-08-2015, 04:52 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Grand Total Query

    Please attach your sample EXCEL workbook..

    You can either have a Helper Column, or try using Calculated Fields on the Pivot Table..
    Last edited by NeedForExcel; 05-08-2015 at 04:59 AM.
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 05-08-2015, 04:52 AM #3
    ashishmehra2010
    ashishmehra2010 is offline
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Grand Total Query

    Hi Splottoman,

    Please post excel file. No one will type the data for you.

    I guess you are talking about Asymmetric Reporting.

    Regards,
    AM
    Last edited by ashishmehra2010; 05-08-2015 at 04:57 AM.
    Reply With QuoteRegister To Reply
  4. 05-08-2015, 05:10 AM #4
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Grand Total Query

    Sorry guys thought it might have been a case of someone telling me where I need to look.

    I cannot attach the actual file as it is over 10MB.

    Please find attached a smaller version of what I am after.Varification Sample.xlsx
    Reply With QuoteRegister To Reply
  5. 05-08-2015, 05:25 AM #5
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Grand Total Query

    See if the attached data is what you are looking for.

    I have changed the Format of the data a bit..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 05-08-2015, 05:43 AM #6
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Grand Total Query

    Hi NeedForExcel

    That works for me. How did you get the the 'difference' field?

    Thanks
    Steve
    Reply With QuoteRegister To Reply
  7. 05-08-2015, 05:46 AM #7
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Grand Total Query

    Its using called Calculated Fields on Pivot Tables..

    https://support.office.com/en-nz/art...eate_a_formula
    Reply With QuoteRegister To Reply
  8. 05-08-2015, 05:50 AM #8
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Grand Total Query

    Thank you!
    Reply With QuoteRegister To Reply
  9. 05-08-2015, 05:51 AM #9
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Grand Total Query

    Please mark the thread as solved
    Reply With QuoteRegister To Reply
  10. 05-08-2015, 05:56 AM #10
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Grand Total Query

    Please check the pivot sheet.
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to solve total, subtotal and grand total automatically...
    By blorban in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2015, 05:25 PM
  2. formula calculates ratio for Grand Total, not Sub Total for each column
    By vkievsky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2013, 11:26 AM
  3. [SOLVED] Is it possible to have both Grand Total and Grand Average in a Pivot Table?
    By ANS in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-16-2012, 05:15 AM
  4. [SOLVED] Pivot Tables - Calc % using Sub-Total, not Grand Total as base
    By sandi in forum Excel General
    Replies: 1
    Last Post: 12-19-2005, 05:59 PM
  5. [SOLVED] Adding Data Using Multiple Worksheets to Total into a Grand Total
    By Lillie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2005, 04:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1