See the attached
I think this is your formula
It will return this in text form
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Rushing Yds_v10.3.twbx 21.8 MB
Hello, thanks for your help, and sorry if I did not make myself clear. I need to display averages (total, home and away games) across all games in the season of opp team in the first (All) worksheet's table next to averages of the team under consideration, and this is what I cannot figure out. How to display the data I have in the Rushing Y Avg H/A worksheet also in the table I need.
If you are trying to drop a table beneath your graph you will have to do
that on a dashboard. Create one worksheet with your graph and another with
the text table. Filter them both the same an connect them with an action
filter that passes all the filter values from on sheet to the o the and
then place each on the same dashboard an size them accordingly.
On Nov 12, 2017 5:06 PM, "Andrey Kovalenko" <firstname.lastname@example.org>
No, I need the numbers for my table (All worksheet), and just cannot get the correct FIXED calculation, also it feels it should be somewhat simple and I'm just missing something. I have created that graph for the reference only. The numbers in the columns Rushing Yds Avg and Rushing Yds Avg (H/A) of Rushing Y Avg H/A worksheet are correct numbers and I want them to be displayed in the table in All worksheet for corresponding Opp teams.