Thanks for your help. I don't want to display the itemname in the dimensions. I just want how many itemname of particular manufacturer is having scheme. I just want count of itemname with scheme. Hope you understood my requirement!
I did the same as said but i think it is not working as expected. It think it is not showing the exact no of items. To check it you an create a list box for item name. Click on any rows in the report which you have created and count no of related rows in itemname list box. It is not matching!
In the attached document in "Top moving product with scheme" straight table it shows all the items with scheme. But when i select the "#MED INDIA (GENERAL)" in the sraight table created by you as per your straight table it says it has 169 items with scheme and as per my straight table it doesn't contain any items with scheme.
I think if i select some other mfacname other than this ( "#MED INDIA (GENERAL)") i think it shows the correct value. Let me know where we are going wrong!
There is not much changes when compared to the one which you have sent. You just need to add a list box of the field itemname. Anyawy have attached it for your reference. Hope to receive some solution from you soon!