In cross tab i've a field in the column (In Cross Tab Expert) eg: Days.

That is 1 to any number of days (based on the data). So that horizontal portion will grow... right ?. In each day some Amout will be displayed in the summarized field in cross tab expert (eg: Amount is the field).  But i would like to display that Days field value from 1 to 5 with the corresponding amount. Then 6 to remaining values the amount value has to consolidated and display in the 6 the colum value itself. how to do it. any idea....

 

Like the following i would like to display here i didn't give the rows details. As it is some row details will be displayed...

 

day1  day2  day3  day4  day5  day6/Consolidated

100    200    300    400   500    3200

 

Thanks in Advance

PAD