2026 Week 25: Can you show difference from selected Sales?

Introduction

This challenge is similar to other challenges, except you’re trying to think differently. Previously this challenge would have been done with LODs or Table Calcs, whilst using Parameter Actions. But you don’t need those fancy Table Calcs or LODs to make the basis of this to work.
Yes this does contain some hacky elements, mainly because I was trying to replicate a challenge created in Power BI. Which I would highly recommend to check out.

Requirements

Dashboard size 1000x800px
Min 2 Sheets. Could be more if you wanted
Match most formatting and functionality – alternatively provide a different look and feel

Couple of hints:

Avg(-1) is your friend
Dummy highlighting or Filtering works a dream
Grand Totals are the “None Selected” Option, which may require an ATTR() function somewhere

Dataset

Superstore 2026. Available from here.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WOW2026 in your description to make it searchable!