This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions


Pivot Table groups the data

Okan Sutcuoglu
Okan Sutcuoglu Member Posts: 121 Red Ribbon
edited Feb 19, 2018 5:49AM in JDeveloper and ADF

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.



Best Answer

  • Timo Hahn
    Timo Hahn Senior Principal Consultant Cologne, GermanyMember, Moderator Posts: 39,056 Red Diamond
    edited Feb 19, 2018 5:10AM 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.



This discussion has been closed.