Drilldown using Set Analysis

[#1]

I used set analysis to aggregate data on a straight table.

I have created 3 aggregated measures namely # of Files Received, # Files Loaded and % Files Loaded.

I would like to drilldown from the % Files Loaded column and display only the records that were not loaded.

Instead, I am getting all the records equal to the # of Files Received.

I am enclosing a sample app for your reference.

Appreciate any ideas.

Thank you.

[#2]

Hi Anthony,

see the modified example for an idea how it could work.

Good luck!

Rainer

[#3]

Hi all,

Rainer's solution works perfectly.

Here you are other solution using set analysis.

Best regards.

[#4]

Thanks Rainier and Miguel.

I am now able to display the records that are not loaded but faced another problem.

I need to display all data in the straight table if I have not filter on the Summary table's % Files Loaded column.

1. Is there a way to accomplish this with one table ie. Display files not loaded when % Files Loaded is selected and display all files when % Files Loaded is not selected ?

2. Or can we toggle between tables once the % Files Loaded is triggered or selected ? This will give an illusion to the user of having just one detail table.

Thanks again for your thoughts.

[#5]

Hi Anthony,

now we toggel between both tables.

Rainer

[#6]

Thanks Rainer.

One last question. Is there a way to render certain columns clickable and non-clickable ?

In the summary table, only the % Files Loaded should be clickable, the rest are non-clickable.

Thanks again.

[#7]

Hi Anthony,

so far I know unfortunately not.

Rainer