I am using matrix table for my report i have one row user name and and column product and data sales.In the product column i have two products A and B .I have created parent group in region in the row group.
My query is if the product is not available in some regions i want hide the product column but its showing A product is empty and genarating B product data
I am expecting output like the attached image
It's been a few years since I've done SSRS design, and I'm not particularly advanced, but I don't think you can do that directly using the Tablix control. The column pivoting is based on the entire set of values, not just for each row group.
The only workaround I can think of is to have an extra row group section for Territory, and embed the Tablix within that section, with the normal Tablix for User and Product. You may need to embed the Tablix within a List or other container in that Territory row group.
I apologize for being vague, I don't have SSRS installed to do a check.