You need to use table calculations to hide the values then only it wont impact the average values
Is there any way you can attach a sample data
Thanks for replying Naveen !
I tried the table calc solution that I found in the forum elsewhere but it still appeared to be filtering the underlying data I need away.
I've attached the .twbx file with the viz I've been working on.
Any help would be awesome!
sport_example.twbx 27.7 KB