Last Modified Date: 31 Dec 2019
AnswerThe 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]) ENDOr
IF SIZE()= 1 THEN 0 ELSE SUM([Quantity]) ENDOr
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.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials