I am making one report with the help of matrix in rdl. the column structure like Category, Brand and product. I have used grouping over there. Category "+" sign you will click then Brand list will get open in another column. My query is I am calculating DIO over there, eg. I have two products p1, p2 in Category A. There DIO are 69 and 13 product wise. In Category wise it's giving me sum i.e 82. But Actually it gets calculated category level. which I am unable to do.
Category Product DIO
Logic for third column is like (159/1116)*90=13
So same will get calculate for Category level.