total for dimension in straight table

[idogridish2]

Hi,

I wont to display total count for activity.date so insted of using it as a dimension i am using it as an expression and showing total count,

but it is summing the activity.date as it should but i dont wont it to sum i need it to show the raw value.

i tried to remove the sum but it didn't work.

please your kind advise.

see the attached.

[Frank_Hartmann]

like this?

[idogridish2 · Accepted solution]

thank you but i managed to solve this issue by adding the activity.date field as a dimension

and hide it :

then i had to wrap the filed like this - > text(Timestamp(Activity.Date))

qvw attached.