0 Replies Latest reply: Jan 17, 2013 1:26 AM by Himanshu_Garg RSS

    BAM : Crosstab : Need to get percentage of row total for each cell


      I am new to BAM. I have a requirement for which I am using crosstab. Basically, I need to show number instances per human task per user. Human Task is the row header, user is the column header, and I am using count(instance id) to fetch the count of instances. I am able to show the sum of values for each row and column, but I also need to show the percentage for each cell(based on row total).

      I do not know if it is possible to fetch the total for further calculations. I believe the calculated field will be processed for each cell, and hence there will be no sum available.

      Also, crosstab does not have a percent of total aggregate function.

      Kindly advise.