Hi,

I have an analytic chart on my dashboard ,When i deploy this dashboard and right click on show details option for any analytic chart,this gives me all the rows from the cube and not the actual number of rows that it is displaying on the chart.for eg:-

my series contains :-Count of products sold.my bottom axis contains products (coffee-6,tea-8,milk cartons-20 )and my filter contains:-city names.

When i click on show details on say tea :- Only 8 rows of tea sold should be displayed as shown correctly in the chart.But It shows me all the rows with tea ,those that are sold as well as those that are still in stock.

I am really confused about this behaviour.If i add the sold/in-stock status filed in my background .The show details option is disabled.Is it because i cant have multiple items in the background of the report???? How can i get only those rows??