Sum Averages in a Cross Tab

I’m working with a cross tab. In my rows I put the item no, item description and item type. In my columns I put Quantity Ordered by Month/Year. I use the Average Function to get an average of those months. The tricky part is that I need to get a grand total of those averages to calculate what percent is the average in each row against the grand total. Webi doesn’t allow me to summary those averages.

what workaround do you suggest??


kikesegarra (BOB member since 2004-01-13)

Have you tried ForEach Operator available. Play around it, I guess it will work. I am not sure though


atulagautam (BOB member since 2009-08-31)