Show Sum and Percentage in a matrix RSS

• • Reply
  

  fiorano

  Member

  108 Points

  371 Posts

  Show Sum and Percentage in a matrix

  Feb 22, 2013 01:34 PM|LINK

  Hi, I have a dataset with the following fields :

  • staff_name
  • type
  • month
  • year
  • total

  Im able to build a matrix to show the sum, but I cant work out how to show a % of the total per year.

  		2011		2012		2013
  		Total	%	Total	%	Total	%
  J Smith	TYPE2	1050	66%	2167	62%	322	70%
  	TYPE3	531	34%	1350	38%	139	30%

  Can anyone suggest an expression for the % calculation?

  I Appreciate any help,

  Many thanks,

  Fiorano