> ## Content Index
> Fetch the complete content index at: https://www.vizney.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Hide Duplicate Subtotals for Single Sub-Items in Tableau
- URL: https://www.vizney.com/tableau-hide-duplicate-subtotal/
- Published: 2026-03-20T02:00:52.000Z
- Updated: 2026-03-20T02:10:15.000Z
- Author: Yehwan Hwang
- Tags: Tips & Tricks

When adding subtotals to a table with two dimensions on the Rows shelf, Tableau duplicates the row if the second dimension has only one sub-item. This quick guide explains how to use a table calculation to hide these redundant rows and leave only a clean subtotal.

![](https://kr.vizney.com/content/images/2026/03/image.png)

1. **Create a Calculated Field for Single Values**  
Create a boolean (T/F) calculated field to count the distinct number of items in the second dimension and check if it is greater than 1.  
`WINDOW_COUNT(COUNTD([Second Dimension Name])) > 1`

![](https://kr.vizney.com/content/images/2026/03/image-2.png)

1. **Apply and Edit the Table Calculation**
  1. Drag and drop the calculated field onto the Rows shelf, right next to your second dimension.
  2. Right-click the field on the Rows shelf, select **Compute Using** and check only the **Second dimension**. (This calculates the count within the first dimension's pane.)

![](https://kr.vizney.com/content/images/2026/03/image-4.png)

1. **Hide the Duplicate Rows**
  1. In your view, rows with a single sub-item will now display as **False**, and those with multiple sub-items will display as **True**.
  2. Right-click the **False** text in the view and select **Hide**.
  3. Right-click the calculated field on the Rows shelf and uncheck **Show Header** to remove the column from the final view.

![](https://kr.vizney.com/content/images/2026/03/image-5.png)

By following these steps, you can eliminate unnecessary duplicate rows for single items, saving dashboard space and improving readability.

![](https://kr.vizney.com/content/images/2026/03/Hide-Single-Subtotal-1.png)