This discussion is archived
0 Replies Latest reply: Jan 16, 2013 11:26 PM by user434029 RSS

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

user434029 Newbie
Currently Being Moderated
Hi,

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.

Regards,
Himanshu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points