Hi,
Is there a way to suppress subtotals or hide (collapse) constituent values. I would like to show totals only when the user has selected to see all the county data.
as you can here, the table aggregates alright when I use the code below but the "total of total" is not necessary
CASE [showCounties]
WHEN "yes" THEN [CountyName]
WHEN "no" THEN "Total" // if I comment this line out I just get null instead of Total
END
I tried this to remove the entire column but I can't see how to combine two values in to a shelf like calculation
A new Calculated value to replace the two values in the row shelf
if [showCounties]="yes" then [RegionName]+", "+[County] // if ", " could be something else it might work
else [RegionName]
end
So it looks like the feature is built-in with the hierarchy function, the only downside is that it requires the viewer to know or have explained the rollup functionality in the table views