I've been playing around with containers and fast-change chart types (specifically pivot tables and straight tables), and have up against the age old issue of percentages not adding up to 100% when pivoting as the row totals are distinct counts.
Rather than slow things down by having aggregations / set analysis expressions, is there any way I can simply hide the percentages if the chart type is pivot table, and then show again when it's a straight table?
Thanks!