In the formula field, create a calculation similar to the following:.In this example, the calculated field is named "Category or blank" Select Analysis > Create Calculated Field.Right-click Toggle Category in the Data pane and select Show Parameter Control.In this example I will call it "Toggle Category" In the Create Parameter dialog, do the following and click OK:.Click the down arrow next to Dimensions in the data pane and select Create Parameter….The example workbook "Segmented Grand Totals.twbx" downloadable from the right-hand pane of this article, uses the sample data set Superstore to create a parameter to either hide or show the Category. Option 2: Allow the user to hide Category to see Year totals In the Edit Tooltip dialog, click Insert > Sheets > sales per year.In this example, that is the "sales per year" worksheet, navigate to the "sales per year" worksheet to see detailed directions on how it was created. Create a worksheet to show the desired totals.The workbook contains detailed directions for how to create the "Original" worksheet. These directions start from the "Original" worksheet. For more information on visualizations in a tooltip, see Viz in tooltip. The workbook demonstrates how to add a visualization in a tooltip to allow the end user to see the trend across years in the tooltip. The example workbook "Segmented Grand Totals.twbx" downloadable from the right-hand pane of this article, uses the sample data set Superstore. QuestionHow to segment grand totals to create a more detailed summary.įor example, if the highlight table shows a column for every year's sales within each category, we may want to segment grand total by year so that there is a total of sales across all categories for each year.Īnswer Option 1: Use a viz in tooltip to show each year's total in relation to all years
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |