Showing Text Mark Type for Grand Total and Other Chart for Measures

게시 날짜: 13 Jun 2017
마지막 수정 날짜: 20 Jul 2023

질문

In a view that contains multiple measure values and a grant total formatted as a horizontal bar chart, how to remove the bar chart for the grant total so that only the label appears while the rest of the view keeps the horizontal bar chart.

환경

Tableau Desktop

답변

The following resolution applies to the attached example workbook NoMarkTypeTotals.twbx. Please note that such steps will need to be adjusted for certain views that place measure on rows shelf or contain more than a single dimension. For example, the table calculation would need to be computed differently depending on the table layout.

For each measure appearing in the view as a grand total:

Create a new calculated field similar to the following examples:

IF SIZE()= 1 THEN 0 ELSE SUM([Sales]) END

IF SIZE()= 1 THEN 0 ELSE SUM([Quantity]) END

IF SIZE()= 1 THEN 0 ELSE SUM([Profit]) END

Drag these new calculated field to the Columns shelf to replace the existing measures.
Right click them and select Compute Using > Table (down).
For each new measure's Marks card, add the original measure to Label.