In the formula field, create a calculation similar to the following:.In this example, the calculated field is named "Sales (hide some total values)" In the Calculated Field dialog box that opens, do the following, and then click OK:.Select Analysis > Create Calculated Field.Note, the total row or column will still show as a blank row. In a view with subtotals for Category and Sub-Category, hide total values for specific dimension values. Scenario 3: Hide total value for dimension value To view these steps in action, see the video below: Right-click Profit on the Measure Values card and select Total Using > Hide.These steps only work in Tableau Desktop, and there is not currently a web-authoring alternative. In a view with the measures Sales and Profit, display total values only for Sales. Scenario 2: Hide total values for a measure Add any additional desired dimensions to the view.Add only the dimensions that you want subtotals for to the view.Please note: The videos may have been created in an older version. To view theses steps in action, see the video below: To remove unwanted subtotals, right-click Sub-Category on the Rows shelf and then uncheck Subtotals.Select Analysis > Totals > Add All Subtotals.In a view that has the three dimensions Category, Sub-category, and Segment on the Rows shelf, display subtotals only for Category. Scenario 1: Remove subtotals for a dimension Option 1: Tableau Desktop Only Directions to create "original" are in the workbook. The workbook in the right-hand pane of this article uses the sample data set Superstore to demonstrate all of the following solutions.Īll solutions start from the "original" worksheet. QuestionHow to display some totals (subtotals or grand totals) and hide other totals.ĭepending on which totals should be hidden the solution will vary.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |