You can achieve something like this after a fashion - though it's a bit hard to format it nicely. Here's what I managed to do with the coffee sales data:
Have a look at the calculated fields in the workbook. The secret is in the use of the PREVIOUS_VALUE() function, which let's you build up a field by appending to the value of the field in the previous row. I then use WINDOW_MAX() to select the highest value of that field (ie the value on the last row - by which time all the values will have been appended together).
If you want the numbers formatted properly you'll have to do that with further messy calculations. There are examples of how to do that elsewhere on the forum.
Tabular tooltip.twbx.zip 161.8 KB
thanks richard ,i will try your solution.
do you have any other sample workbook with tabular tool tip ?