forums

Tableau has a nice feature that allows for calculating percentages of rows, columns, etc. Occasionally, I find myself wanting to calculate the percentage, but then I want to display only one of the panels in the result. This is especially common for yes/no type breakouts; displaying both values (yes and no) seems redundant in these cases. So what I'd like to be able to do in these cases is to exclude one of the panels AFTER the percentages have been calculated (excluding it before doing the percentage calculation, which Tableau offers, would alter/destroy the percentage calculation).

In most cases, I can use a workaround by creating a calculated field to compute the percentage (using IIF and SUM statements). But it would be nicer, and faster, if Tableau offered a hide feature after doing the percentage calculations.