Pivot Table groups the data

Okan Sutcuoglu

Hi everybody,

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

The data is like this :

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.

Timo Hahn

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

Timo Hahn

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

Okan Sutcuoglu

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