This content has been marked as final.
Show 2 replies
-
1. Re: Change measure for Chart A when filter/action is being used on Chart B
Jim DehnerNov 29, 2018 12:36 PM (in response to tadd.wagner)
Hi Tadd
see the attached
I added your calculation for rank to the second sheet
I also added the profit ration to the second sheet just as a check - you can just leave it out and hide the ranking
it returns this
-
2. Re: Change measure for Chart A when filter/action is being used on Chart B
tadd.wagner Nov 29, 2018 1:18 PM (in response to Jim Dehner)Hi Jim,
Thank you for the comment, but I think I'm still looking for something else. I'm trying to get to an end result that is the middle of my above attached screenshots.
In general, I want to have two sheets: Sheet A and Sheet B. Both are sorted by Measure A. When using the filter action on Sheet B, I want a different measure, Measure B, to show on Sheet A.
Hopefully that makes sense.