relational package create SET with data item to show only sub item display

[clingst]

Good day all

I am having a relational package.

Says if i have 2 major group of product ..
and i only want to shows the sub item for one of the group at the upper part of crosstab
but at the bottom part.. i wanted to shows the grand total of BOTH group..

Please advice how can i do that...

I tried with the case statement to control the measures for my sub item [case the measure to 0 for the 2nd group and remained the 1st group measure)

however this also turning the value for my grand total .. although i created second data item for the grand total measure..

i have attached the sample ...
appreciate for advice how can i work aroudn on this..


thank uuu