Aggresgate Summary View to a Detailed View

building reports webintelligence
1

Drill options
I want to have a summary table with data like below,
MSc Actual Preffix MSc Spoofed Preffix Combination Count
1234 4321 1
1234 4322 10
1234 4323 5
Detail Detail (substr of the 10char MSc Spoofed string)

I then want to be able to drill down through this Summary data to then display the detailed info from the report selecting only the records with the combinations as per the summary table.
For example drilling on record 2 wold result in a display of the detailed table of only 10 records as per the screenshot.
Maybe Drilling isn’t the most suitable way to realise this?

eberwick (BOB member since 2008-12-08)

2

You should be able to drill into the ID that makes up those 10 unique rows, though sometimes ID’s at that level are sometimes classified as detail objects - is the id part of the defined hierarchy?

dessa :madagascar: (BOB member since 2004-01-29)