A quick question

[#1]

hi

i worked out a table like below by each timepoint, the expression is "

(

sum(aggr(if(Sum({$<PLAvailability_ClassStatusCode={'Booked', 'Finished'},PLAvailability_1dayflag={'1'}>}PLAvailability_ClassCount)
/
Sum({$<PLAvailability_ClassStatusCode={'Booked', 'Assigned', 'Finished'},PLAvailability_1dayflag={'1'}>}PLAvailability_ClassCount)<>1,1,0),PLAvailability_TimeSlot,PLAvailability_InsertDate)))
/
24

"

LodingTime	DAY1 % of Available Slot
1/2/2014 0:02	4.20%
1/4/2014 18:02	4.20%
1/6/2014 12:02	4.20%
1/6/2014 18:02	4.20%
1/7/2014 6:02	4.20%
1/7/2014 12:02	4.20%
1/8/2014 6:02	4.20%
1/8/2014 18:02	4.20%
1/9/2014 0:02	4.20%
1/9/2014 6:02	4.20%
1/10/2014 0:02	4.20%
1/13/2014 0:02	4.20%
1/13/2014 6:02	4.20%
1/14/2014 6:02	4.20%

now i want to show the average number by year month

YearMonth	LodingTime	DAY1 % of Available Slot
201401	1/2/2014 0:02	4.20%
	1/4/2014 18:02	4.20%
	1/6/2014 12:02	4.20%
	1/6/2014 18:02	4.20%
	1/7/2014 6:02	4.20%
	1/7/2014 12:02	4.20%
	1/8/2014 6:02	4.20%
	1/8/2014 18:02	4.20%
	1/9/2014 0:02	4.20%
	1/9/2014 6:02	4.20%
	1/10/2014 0:02	4.20%
	1/13/2014 0:02	4.20%
	1/13/2014 6:02	4.20%
	1/14/2014 6:02	4.20%
	1/15/2014 6:02	8.30%
	1/16/2014 0:02	4.20%
	1/16/2014 6:02	4.20%
	1/17/2014 6:02	4.20%
	1/17/2014 18:02	8.30%
	1/18/2014 0:02	4.20%
	1/19/2014 6:02	4.20%
	1/19/2014 12:02	4.20%
	1/21/2014 6:02	4.20%
	1/22/2014 0:02	4.20%
	1/23/2014 6:02	4.20%
	1/25/2014 0:02	4.20%
	1/26/2014 6:02	4.20%
	1/26/2014 12:02	4.20%
	1/27/2014 6:02	8.30%
	1/28/2014 6:02	4.20%
	1/29/2014 6:02	4.20%
Total		141.70%

i just want to Total to be the average of those numbers , how can i do that?

[#2]

what i mean it is currently giving me the total, i want to average

[PrashantSangle]

Hi,

In Expression tab->total Mode->Select (Sum )of Rows

Or

Expression tab->total Mode->Select (Avg )of Rows

[#4]

it just greyed out, can not choose it

[PrashantSangle]

Hi,

I am considering that you are using Straight table

regards,

[#6]

It seems you are using a Pivot Table. Convert it to a Straight Table and the option should be available to you.

Rgds,

SK