Skip to Main Content

Analytics Software

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!

Filtering data by aggregation like group by ...having count(*) >1

fabryddorf-OracleApr 10 2018 — edited Apr 15 2018

Hi All,

On the below report I am trying to filter by guests who stayed in more than one hotel. Theoritically I should display only guest where the sum by guest >1

Any idea? I obtained the some simply in Pivot table on Guest name

aggregation.jpg

This post has been answered by Martin van Donselaar on Apr 11 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details