2025 Week 33 | Sigma : Can you cross filter tables?

Introduction

Welcome to Week 33 of 2025!

We’ve all been there: you want to cross filter a dashboard by clicking on a field, and just as easily clear the selection. With charts, it’s easy – just click the white space. But with tables, it can be a little trickier.

This week’s challenge: master cross-filtering from table elements using conditional actions and hidden controls. Ready to make your tables as interactive as your charts? Let’s do it.

Good luck!

-Jess

Need access to Sigma?

Click here to Watch: How to Register & Get Started with Sigma WoW

Note: You will only have view access to WOW Workbooks, Folders, and Workspaces, not edit access. Please create your WOW Workbooks under “My Documents.” We suggest creating a folder to organize all your workbooks.

Requirements

Hidden Data Page:
- Create a table element with the source:
  - Data Sources > Connections > Sigma Sample Database > Retail > Plugs Electronics > Plugs Electronics Hand On Lab Data
- Create a hierarchy made up of Product Type, Product Family, Product Line
- Create new calculated fields for revenue and profit
- Create three single select list controls off of the table element
  - Product Type
  - Product Family
  - Product Line
Dashboard Page:
- Add three KPI tiles to show revenue, profit and profit margin
- Add a pivot table element to show sales metrics by the product hierarchy you created – feel free to add any sales metrics you think would be of interest!
- Add actions on the pivot table to set and clear the controls on the hidden page based on clicks – hint: try using conditions to help with when to set/clear the controls!
Extras:
- Give your dashboard a branded theme and logo
- Add any page controls that might be helpful to an end users
- Spice up your KPI tiles with comparisons and trends

Dataset

Data Sources > Connections > Sigma Sample Database > Retail > Plugs Electronics > Plugs Electronics Hands On Lab Data

After you finish your workout, share on LinkedIn, Sigma’s Community page, (or Twitter) using the hashtags #WOW2024 and #SigmaComputing, and tag Ashley Bennett, Eric Heidbreder, Jess Batten, Carter Voekel, and Michal Shaffer!

Create an interactive, sharable version of your solution here.

Also, make sure to fill out the Submission Tracker so that we can count you as a participant this week to track our participation throughout the year.

Solution

Coming Soon…