I'm having problem with some Row Groups in a Matrix.
I have the following group hierarchy:
Channel (as in where my products are sold)
Category (as in what Category the specific product is
Category/Channel (as in how much a category is sold in which channel)
MerchandiseGroup (what merchandise group my product belongs to)
MerchandiseGroup/Channel (you kinda get the picture here)
ProductGroup/Channel (yep the same as before)
Now ... every ProductGroup has an Amount, the amount sold. So ... to show the amount sold of each group in my dataset I have a column for
each group and the ProductGroup/Channel beeing the last of them.
Cat/Channel ... MerGrp/Channel and PG/Channel are created in the dataset as Select ... blablabla , Category + ' ' + Channel AS 'CatChannel'
... and so on for the other 2. But every row i nthe dataset has the correct Amount.
So ... in the Data fields I have ...
And here comes my problem:
It works for the following rows ... groups:
Total - OK
Channel - OK
Category - OK
Category/Channel - EMPTY ... ??????
MerchandiesGroup - OK
MerchandiseGroup/Channel - EMPTY ... ??????
ProductGroup - OK
ProductGroup/Channel - OK ... ?????? why here and not the others?
So what I tried to do is to delete the child groups and kept Cat/Channel ... and then this group show the correct Sum(Fields!Amount.Value)
If I delete up to MerGrp/Channel ... then neither of them shows anything.
What am I doing wrong?
Thanks in advanced!!