Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2009
    Posts
    8

    Unanswered: Help on PivotTable..

    Hi,

    I am having some trouble with using Pivot Table. I have attached the excel sheet below.

    In my case, i would be taking data from SQL tables and exporting to Excel "RawData" sheet. From this sheet i have designed a Pivot Table.

    The following fields are displayed in RawData sheet:
    Code:
    Location
    BranchID
    Total Count
    ScanDateTime
    DataDateTime
    Longest Elapsed Time (DataDateTime - ScanDateTime)
    Average Elapsed Time (Average of all Longest Elapsed Time)
    Now, my requirement for designing Pivot Table is:
    Location,BranchID - shown at Row Area

    Total Count,ScanDateTime,DataDateTime,Longest Elapsed Time ,Average Elapsed Time - shown at Data Area

    However im facing the following issues after designing the Pivot:

    1) The Grand Total Average Time shown after all rows is Incorrect
    2) The Grand Total Longest Time shown after all rows is Incorrect
    3) I do not want to include ScanDateTime,DataDateTime in every Location Level Total row and Grand Total row but by default it is showing.
    4) The format for all the Data Area fields listed above is not proper.

    Have a look at the attachment and let me know your views on the above issues im facing.

    Sankur.
    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
  •