Forum Stats

  • 3,838,621 Users
  • 2,262,385 Discussions
  • 7,900,705 Comments

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.

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

Tagged:

Best Answer

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,585 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.

    Timo

Answers

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,585 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.

    Timo

  • Okan Sutcuoglu
    Okan Sutcuoglu Member Posts: 121 Red Ribbon
    edited Feb 19, 2018 5:49AM

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

This discussion has been closed.