Hi, Please refer below for the details. I have provided a screenshot of the req here. I I need to display the levelDistribution groupings in a tablix report. The given below are the level distributions i am having. Level Distribution Sr.Manager & Above Manager Senior Consultant Consultant Freshers I need to show the billablity only for managers and Sr. Managers & Above in the report without displaying the Freshers,consultants and Seniour consultants. But there is a last column , All levels for which i need to show the billability of all the levels (Freshers,managers,seniour managers,consultants etc.,) I am using a tablix and a column group by LevelDistribution , so i am displaying all the levels in the report, which is not desired. I tried to hide the visibility of Freshers,consultants and SC's. But then they are getting hidden , but there is a empty space coming at the hidden area. Hence not desired. I tried using a normal table instead of a tablix and then in each column group on Level distribution then filter each Level say Manager in first column grouping, Sr.Manager and above in second column grouping. But I am not able to use the same grouping for two column groups. Is there a way how can we acheive this. Please revert. Thanks, Srihari

Are You Using a SQL Code are MDX ?Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Rakesh I am using MDX

Hi Srihari, Why dont you create a Set with Required Members {Leveldistrbution.manager,etc....} and Use it in MDX and also use ALL level if you Require.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Rakesh, I have used the set with the required members , the only issue is with the All level. if i use the all member then i will get all the members , including freshers etc., Can we create a separate set and then use the value directly in the Tablix for all levels ? Please send me if you have any pseudo code for this. Thanks, Srihari

Hi, Use a Tablix instead of a table and Follow the Below. 1.Write an Mdx like this select {[Product].[Product].&[1],[Product].[Product].&[2],[Product].[Product].[All Products]} on 0, {[Geography].[Country].members} on 1 from [Adventure Works] where [Measures].[Internet Sales Amount] 2.Drag and Drop your Measure in Row,Column and Data Fields.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Rajesh, I have solved the issue. I have created an mdx to get the data for all levels by removing the leveldistribution on rows into a new dataset . Then i have created a separate tablix with the new dataset. I have made the width for all the columns except the data that i need to show to zero(minimum width, since we cannot make width to zero) and made them invisible. I have placed the two charts side by side in a rectange and i am able to show it in the format i need to get. Thanks for the reply. You have a nice day. Srihari