I have a bit tricky business requirement, let me try to explain it. In this picture attached I have Python created fields. My requirement is to created these stats fields that will be calculated based on the date selected from the slider and Returns calculated. Python code calls a already defined function and calculates these stats,
The data and output are correct. However, I have to keep all these into tool tip because they are repeated for every value of Date and Code in table. I get the same stats for every blue box(detail) on the sheet. This is due to the fact that I have placed the dates on sheet. I want to show it only single time like in one table, with only stats and values no dates and codes on sheet but still used during calculations. I am not sure how to do that.
Please let me know if further clarification is required.
ps: I tried to upload a screenshot but I am not able to due to some privacy settings. Thank you for understanding.