The code have 3 Product View on header as Jewelry, POSM, Exclude. The Exclude product view is sub-categorized into three - ProductType1, ProductType2, ProductType3. So, the requirement is that header of the report should show 3 Product View on header as Jewelry, POSM, Exclude but main report must have table designed in such a way that when we select - "Exclude" from header, it should show Product No and its sub category.
The problem lies that Product view - Jewelry and POSM is from dimension table whereas Product view - Exclude is from MDS table.
Kindly help on this.