LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 14th 09, 01:41 AM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Feb 2009
Posts: 10
Default Getting Two Rows in A Pivot with Identical Data

Hi All,

I hope there is some hope for me. I even think this might be easy, but I'm
literally spending hours trying to figure it out.

When I run my pivot, I have data that has the same row information, but the
Pivot only shows one row, it will now show the row seperatly.

My Data is as follows:

Report Date Time User Elapsed Data Seconds
Report A 11/3 8AM User 5
Report A 11/3 8AM User 5
Report A 11/3 4PM User 7
Report A 11/3 4PM User 10

While two rows show that Report A on 11/3 Ran at 11AM for a user, and the
time it took was 5 Seconds, the pivot will not show two rows of data, it will
only show one. I need two rows of data, because I'm running another forumla
along side the pivot that will give me a count of how many times Report A was
run. So right next to the Pivot I need to show a total count for Report A of
4. Because my Pivot is only showing one row of data for the 8AM run, I cannot
get my count correct. The Total for the AM run is correct at a total of 10
Seconds, but I need to see two Rows. I'm running over over twenty or so
reports, so my real data looks like Reports A through Reports Z, with
periodic instance where one report was run at the same time for the same
duration. Each time and only when this happens, my count that is running
along side my pivot table is off. I have have to run the count along side the
pivot as part of my project.

My Pivot looks like this:

Sum of Elapsed Data Seconds
Report Date Time Elapsed Data Seconds User Total
Report A 11/3 4PM 7 User 7
10 User 10
8AM 5 User 10

Any assistance at all and I would VERY GRATEFUL!

Thank You!

Holman's World Inc (R)

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
extract identical rows from 2 excel file Rose[_2_] Excel Worksheet Functions 0 March 13th 08 11:11 AM
Merging two sheets with non-identical data Robert_DubYa Excel Discussion (Misc queries) 1 November 13th 07 09:29 PM
compiling data with non-identical subjects kate Excel Discussion (Misc queries) 1 October 6th 07 09:09 PM
COMPARE IDENTICAL DATA holagigi New Users to Excel 3 June 27th 06 08:21 PM
I have two identical pivot tables with different sort order of th. WilliamJFoster Excel Discussion (Misc queries) 1 April 7th 05 03:48 AM

All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017