Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there an easy way to align the values for Secondary Dimension totals in a bar chart? I attached an example of what Im trying to do. Thanks.
One trick is mark only one expression to show values and change the expression to something like:
dual(
sum(Expression1) & chr(10) & sum(Expression2),
sum(Expression1)
)
it´s important to uncheck any number format at Numbers Tab
I altered my expression (which is written specifically to provide ONLY the total values) based on your advice above:
Dual(Sum([GLOBAL Efforts: Enhancement])& Chr(10)& Sum([GLOBAL Efforts: Mandatory]), Sum([GLOBAL Efforts: Enhancement]))
It appears my total values shifted down from their original location but still remain centered to the "Quarter" Dimension instead of the "Year".