Hi I have measures like delivered_count bounce_count open_count click_count Total Count 10 20 30 40 100 can i show this data in pie chart thanks, Chakri.

Hi, You shoud not include the TOTAL in the pie chart, otherwise it does not represent the correct picture. You can filter out row containg the total using dataset filter.- Chintak (My Blog)

Hi Chintak, so my dataset is with these measures delivered_count bounce_count open_count click_count 10 20 30 40 so should i need a catogery field compulsory ? how can i bind these measures directly to the pie chart ? Thanks, Chakri.

Hi, If this is your dataset declare @table table ( mesure nvarchar(100), value int) insert into @table select 'delivered_count',10 union all select 'bounce_count',20 union all select 'open_count',30 union all select 'click_count',40 select * from @table Add a pie chart, add mesure to category and then add value to Value. Now, this will dynamically change once new measure is added - Chintak (My Blog)