Extra dimension value showing sum of all other dimension values

[SimonDB]

Hi, I have a bar chart that has location as a dimension and has two expressions that sum quantity by period in time.

I need to add an additional dimension value "All Locations" into the same bar chart which sums the values of the other dimension values, so the resulting values of "All Locations" would be:

June 17 to May 18 - 17.28

June 18 to May 19 - 14.96

Any help would be greatly appreciated, thanks, Simon

[saminea_ANZ]

Let's say your values comes from Sum(Values)
For that, You can call out using Dual() as
Dual([Period in Time] & Sum(Values), Sum(Values))

[SimonDB]

Hi, where would I place the above?

My dimension is:   

=if(BRANCHLIST.STATUS<>'CLOSED',BRANCHLIST.TYPE)

My expressions are:

=sum({<PERIOD={1},PROD_CODE={'1.913.683','4.552.765'}>}ORDER_FULL_QTY)

=sum({<PERIOD={2},PROD_CODE={'1.913.683','4.552.765'}>}ORDER_FULL_QTY)

Thanks, Simon

[Brett_Bleess]

Simon, any chance you can attach a sample app, I think that may help in this case get you what you need.

Regards,
Brett