Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have several sheets that show employee statistics for date range. Each dimension (department, manager, month, etc) is set to show partial totals by default in the sheet. Is there a way to allow the user to toggle these totals on/off?
By using macros you can do
Below is sample
set chart = ActiveDocument.GetSheetObject("CH06")
set cp = chart.GetProperties
set dims = cp.Dimensions
dims(0).ShowPartialSums = false 'false - do not show sums, true - Show partial sum.
chart.SetProperties cp
If you're using QV11 it's easier to add the dimension twice, once with partial sums enabled and once without, and use the conditional display expression to toggle between the two. See attached example
Hi Brian,
I got it fixed with dimensionality().
Might not be a very dynamic solution, but it fixed my table.
The Total has two dimensons. These are the first two columns of my table. Please see png.
if (Dimensionality()=2, '',
sum(Material.GivAmount) * sum(Order.Amount)
)
Cheers Bernd