continue to modify the PAT by Summary report for adding per brand and per resources total, the added field is not returning the correct value and found out that in crosstab in 3.9.1 Pentaho report designer, this cannot be added can only be added into Pentaho report designer 4 and up. though still searching for a way as there are some forums that encountered a problem but it is done
modify the query as well, as the total might be added in the query