[ViaanParticipant Started: 1Replies: 2Total: 3]

Now that is a neat trick!!!
Thanks heaps… and i have learned a new formula!

[ViaanParticipant Started: 1Replies: 2Total: 3]

Hi there  Tom,

I have converted the rawdata date field to dd/mm/yyyy.

My Date Table is call Dates.

When I try and add the DateKey to the rows in my pivot table, I dont get date related options. If I perform date calculations on the columns I get an error that I cannot convert text to date even though the column is formated as Date.

Sample attached.

 

Kindest regards,

 

Viaan

Attachments:

You must be logged in to view attached files.

[Author]

Posts