QUICK Question on Report: Date filter with formula - Can't be prompted
I've created a pivot report where some CASE statement has been applied in a Date field due to which its preventing me from making that field "Is prompted" for filters to work in dashboard.
Can you please let me know is it a restriction on a date field i.e. If some formula has been applied then that field can't be prompted?
Though for other fields with formula, I'm able to prompt that field normally.
Appreciate your quick help.
Regards,
Sumit
0