Show Frequency of the Fact Table IDs by a Dimension in the List Box when using Star Schema

[#1]

I have Start Schema Data Model contains one Fact Table and 100 Dimension tables. I have the Dimension IDs in the fact table and Dimension IDs and Descriptions in the Dimension Tables.

I am trying to use the List Box to show the list of a specific dimension Names and its frequency in the fact Table. But since the Dimension name exists only in the Dimension table, it shows ones all the time.

Smaple file attached.

Could you please help by suggesting a way for doing this?

[pover]

Here's what you can do by making it a table and not a list. This is a reason why they improved list boxes in QV 10.

Regards.