October 2, 2018 at 11:58 pm
Hi All,
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.
Like
Category Product DIO
A 82
P1 69
P2 13
| Item | 159 | 1116 | 13 |
| Item | 158 | 207 | 69 |
| Cat | 317 | 2123 | 13 |
Logic for third column is like (159/1116)*90=13
So same will get calculate for Category level.
October 29, 2018 at 2:32 pm
If I understand correctly from your description, you need a column group. The column group is actually the expression that you are describing. This should allow for the click-through calculation you are looking for.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply