Hello All, Is it possible to get the drilldown into the following list? Date, ID, Count of Type 1/1, 1, 50 1/1, 2, 0 1/1, 3, 30 So if there no data for certain IDs, the matrix show them as blank? But the format is 1 ~ 10, even if only half have values Hope it makes sense Cheers Simon

If I undrstand your question correctly, this should be the default behavior. I'm confused by your use of the term "drilldown". What are the group levels used for drill-down? I'll need more details and background about your design.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com

If I undrstand your question correctly, this should be the default behavior. I'm confused by your use of the term "drilldown". What are the group levels used for drill-down? I'll need more details and background about your design.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com