How about creating a sum calculated field for sum of the years expenses using datetrunc and datepart and then bring this onto the tool tip?
I'm relatively new here so apologies if above leads you down the wrong track.
Can you please send me sample syntex..
2 of 2 people found this helpful
Hope you're doing Good!
As i understand your problem, the below images will solve your query. I have shown you the total sales year wise for two years. The calculation is in the screenshot for your reference.
Let me know if this helps.
Thanks & Regards