Only showing one case of group 2
I have group1 as Department and group2 as order type. I am trying to show simple thing like this.Sum of order amts by order type but this is what is displaying:
but only shows the first order type
the problem is only shows one order type only for 1 of the departments, the last one. but all departments have many order types.
why does it show only 1 time
I think when you go with DJ work around that totals will be change. and also the groups names will be repeat depend on the sub groups.
Any way try that and let us know the status...