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