Fecha de la última modificación: 20 Jul 2023
Entorno
- Tableau Desktop
Respuesta
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.
Gracias por brindarnos sus comentarios sobre la eficacia de este artículo.
Abrir nuevo Caso
Continuar buscando
Base de conocimiento
Comunidad
Ayuda sobre los productos
Capacitación y tutoriales