Hi,I need help, I created a table of sale by date. I also create a date filter. The table would show data from previous month of the selected date. I want the table to display the first 6 month in seperate column and the other in 1 column. Example, if i filter the date to 30/11/2012, the table should display record of november until june and 180 days and later.

From the image, the filter are set 30/1/202.It will display January untiI august in seperate column.I want to sum "180 days and later" to a single column.