Getting "Per Item" Pivot Chart Results when data rows are identica

[holmansworld]

I've received excellent feedback to assist me tin getting my Statistical
Table to show the Count Values from my pivot when two rows have the exact
data and I need the Statistics Table to show the count of reach row as
oppossed to the sum.

Now the more complex (or maybe not) part is getting a Pivot Line Chart to to
out each point as opposed to tthe sum.

My Data looks like this:

Report Date Time User Elapsed Data Seconds
Report A 11/3 8AM User 5 1 Seconds*(<---problem row)
Report A 11/3 8AM User 5 1 Seconds*(<---problem row)
Report A 11/3 4PM User 7 5 Seconds
Report A 11/3 4PM User 10 4 Seconds

The Challenge:

How do you get a Pivot Chart to show that for Report A on 11/3 at 8AM User 5
used 1 Second, Two Times.

I need my chart to look like this:

-------*-------*-----

Instead, my chart looks like this:

------*------

Each Asterisk will show that there are two instances for user 5 on 11/3 at
8AM for the 1 Second Period.

My Chart does fine for the other users which has unique data (no other user,
date, time have the exact same details).

It seems when a user info is the same on two occurance the Pivot Chart will
combine it as one.

How do you prevent the combination in Charting if the data row is exactly
the same and you want to Chart it (or as in my earlier post "display in on a
table) seperately and not combined?

Thanks for any assistance at all, as mentioned I've spent literally hours
trying to figure this out.

 

[holmansworld]

I just relooked at my data and saw the following:

My Data looks like this:

Report Date Time User Elapsed Data Seconds
Report A 11/3 8AM User 5 1 Seconds*(<---problem row)
Report A 11/3 8AM User 5 1 Seconds*(<---problem row)
Report A 11/3 4PM User 7 5 Seconds
Report A 11/3 4PM User 10 4 Seconds

When I run the Pivot it looks like this:

Report Date Time User Elapsed Data Seconds
Report A 11/3 8AM User 5 1 Seconds*(<---problem row)
11/3 8AM User 5 1 Seconds*(<---problem row)
11/3 4PM User 7 5 Seconds
11/3 4PM User 10 4 Seconds

The Pivot is not showing each report name on each row even though the report
name is the same.

How can I get the report name so show on each row as this may be
contributing to my challenge.

Thanks

 

[Jon Peltier]

There is nothing in the data to show that the two records are distinct.
Either you don't want to use a pivot table, or you need something different
in each record. Call the first one User 5a and the second User 5b, or insert
a field that shows a and b for the two instances of an otherwise identical
record.

- Jon

 

[holmansworld]

Thank You!

I think I may need to at least add a column heading "Report Number" which
will give me the unique criteria you mentioned.

Thanks again!

 

[holmansworld]

Thanks again Jon!

That was it! Using an additional Unique Identifier (I chose Report Job
Number) allowed me to display each instance as I desired in both my Pivot
Table and Pivot Chart!

Again Thank You!

--
http://www.holmans-world.info/
Holmans World Inc (R)

There is nothing in the data to show that the two records are distinct.
Either you don't want to use a pivot table, or you need something different
in each record. Call the first one User 5a and the second User 5b, or insert
a field that shows a and b for the two instances of an otherwise identical
record.

- Jon