1 of 1 people found this helpful
You can create calculated fields to work out the averages for 1 and 0.
Avg0: IF [ID] = 0 THEN [TRANSACTION] END
Avg1: IF [ID] = 1 THEN [TRANSACTION] END
These can be dragged to the Tooltip shelf and set to AVG.
This may too simplistic for what you're actually trying to achieve, in which case please upload a packaged workbook and include some specific examples of what you expect to see.
Hi Andrew :
I forgot to mention that I'm showing the transactions of employees with '1' as their identifier by using a filter. But, in the tool tip I want to the averages of those with '0' too for that particular employee. I can show the avg for '1' in the way you mentioned above but I'm unable to show for '0' as they are being filtered out.
Ok, if you're filtering out the data but also want to show it that complicates things. You could try converting the filter to a Table Calculation filter. This would mean creating a calculated field and having a formula such as ATTR([ID]) and using that calculated field as your filter instead of the ID field.
This may not work in your case, if not I suggest rethinking where you're going to put this information, would be better on a different worksheet which isn't affected by the Id filter so both 1 and 0 averages are always displayed.