Morning all,

I currently have a simple Cross-Tab report created showing the CPU usage of a system over the last week; with a graph also displayed.

What I'd like to do is create a column in the cross-tab (or a formula in Select Expert that does the same thing) that shows the day of the week derived from the date field. The Cross-Tab is setup as follows:

Column 1: Date/Time field (DD/MM/YYYY HH:MM)
Column 1: CPU Usage

I have tried using a Calculated Member column (which keeps saying my formula (below) is incorrect) and also writing the below formula in Formula Fields and dragging it next to the Cross-Tab fields (the formula works but it doesn't attach itself to the cross-table).

Once I can get this working I will then add the other days...

 If DayOfWeek ({System1.DATE_TIME})=1 Then

        "Sunday"

Else

        "" 

Hi DBlank,

That has worked perfectly on the crosstab report I have, thank you!

What I would like, ideally, is to have the date and a separate column showing 'Monday', 'Tuesday' etc. My current (limited) knowledge with Crosstabs can't add a second column with the date field in, but is it possible? Then I can apply this formula to the second date field?