Hi,
I have a requirement to create a pivot table report where my column is a date field, and my row is the group field and I will show the count of tickets. However, I want to use only the year of the date as the column and not the date field. I cannot create an additional field for this in the table as I need to then update a lot of historical data. Is it possible to somehow directly convert the date field to a year field in the report or create a temporary field?
Also, one more doubt can we use a string field as an interactive filter? or is there any way I can modify the string field so that it can be used as an interactive field?
Regards,
Maharshi
