I am working on a Pivot Table to compare the performance of sales people in certain date ranges.
For each data set i have created an aggregate formula using the iscurrentweek, iscurrentmonth, ect.
countif(iscurrentyear("Appointments"."Created Time"))
countif(iscurrentmonth("Appointments"."Created Time"))
countif(iscurrentweek("Appointments"."Created Time"))
I now need a column for Todays data, but am unable to find an istoday or iscurrentday function.
This all needs to be on the same pivot table.
Thanks!