asked on

Showing subtotals

I have a very simple tableau report with a custom pill that groups servers based on in scope or out of scope, I would like to show a subtotal of the count of servers for each of these groups.

Scope Group is just a calculated field so that they group correctly - calculated field shows:

CASE [Server Status]
WHEN "Active" THEN "In Scope"
WHEN "Offline" THEN "In Scope"
WHEN "New" THEN "In Scope"
ELSE "Out of Scope"
END

There are no columns in the report just row pills showing

Scope Group App Code Server Name Server Status Version Targeted
In Scope App 1 Server 1 New bla
App 2 Server 1 Offline bla
Out of Scope App 3 Server 1 Decom bla
App 12 Server 2 Decom bla

I would like to show a subtotal row with the count of Server Status in each Scope Group shows up so that the report would look like this

Scope Group App Code Server Name Server Status Version Targeted
In Scope App 1 Server 1 New bla
App 2 Server 1 Offline bla
SubTotal 2
Out of Scope App 3 Server 1 Decom bla
App 12 Server 2 Decom bla
SubTotal 2

Is this possible? Can someone tell me how to do it? I'm very new to Tableau (day 1)

Thanks!
Gwenna

Mike McCracken

WHen you say tableau report, I assume you mean it is built using the Tableau tool.

Does tableau have breaks and break footers?
That is what it appears you have with the Scope Group.

mlmcc

boukaka

ASKER

Sorry for the delay, I do mean the Tableau tool but it does not seem to have breaks or break footers.

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

boukaka

ASKER

That worked perfectly, thank you.