On Access Point the only way (at least I believe) a user can add sub-totals to an existing chart object is by making a copy of the object first. Once copied they can then edit the properties and add sub-totals to dimensions. This is fine in some cases, but I have a dynamic pivot table that lets users pick what dimensions, from about 100 options, that they would like. I'd like for the users to be able to somehow add sub-totals to the dimensions without having to copy the chart and go through the properties box in Access Point.
Has anyone seen a solution that would allow the user to toggle sub-totals on or off for defined dimensions?
Thanks!
- Mark