Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pivot Table groups the data

Okan SutcuogluFeb 19 2018 — edited Feb 19 2018

Hi everybody,

I am using JDeveloper 12.1.3 and I create a pivot table but it groups data automatically.

cikti.PNG

The data is like this :

data.PNG

Same sipno and hat but start times different.

I want to do is :

A2 418 06:00:00 Evyap 125000

     373     21:29:08    Evyap   25000

     373     22:48:00    Evyap   25000

I create the pivot like this and dont do any sum or grouping. Just next next.

create.PNG

This post has been answered by Timo Hahn on Feb 19 2018
Jump to Answer

Comments

Timo Hahn
Answer

Isn't this exactly what you told the pivot table to do?

The two records can't be distinguished with the given values of startdate,  hat and sipno.

You can add the starttime to the row edge and you should see the two rows.

Timo

Marked as Answer by Okan Sutcuoglu · Sep 27 2020
Okan Sutcuoglu

Main problem here is i misunderstood pivot table's work principles. Thank you.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 19 2018
Added on Feb 19 2018
2 comments
202 views