3 Replies Latest reply on May 29, 2016 7:57 PM by Ahmad Naim Ahmad Rosdi

    Combine date column using IF into 1 column

    Ahmad Naim Ahmad Rosdi

      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.

      Screen Shot 05-23-16 at 03.42 PM.PNG

      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.