# Beast Mode - Refer to Other Segments in Case Statement

Basically, what I'm looking to do is create a percentage column in the dataset.

For example:

Let's say I have some shapes: 'Rectangle', 'Square', 'Small Square'

How would you go about creating a variable that shows the percentage of that shape as compared to the next largest category of shape? For example, the column would show:

100% for 'Rectangles'

SUM(Number of Squares)/SUM(Number of Rectangles) for 'Squares'

SUM(Number of Small Squares)/SUM(Number of Squares) for 'Small Squares'

I've tried a CASE statement, but it doesn't seem to work given that it excludes all Rectangles when I subset for Squares.

Also, I'm unable to use ETL or preprocessing because the data needs to be able to be filtered by many different variables. Enough variables to make it prohibitive to calculate this for all combinations of these filters, which is why it needs to be able to be calculated in a beast mode.

Thanks!

#### Categories

- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 681 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 9 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive