上次修改日期 : 20 Jul 2023
環境
- 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
OrIF SIZE()= 1 THEN 0 ELSE SUM([Quantity]) END
OrIF 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.
感謝您針對本文的效益提供意見回饋。
開啟新案例
繼續搜尋
知識庫
社群
產品說明
訓練及教學課程
Trending Articles
Results 1-3 of 50