
Re: calculation  range sum
Jonathan Dienst Oct 28, 2015 5:45 AM (in response to Joanna Seldon)For difference you just need:
=Sum(ORDERS)  Above(Sum(ORDERS)

Re: calculation  range sum
Jonathan Dienst Oct 28, 2015 5:45 AM (in response to Jonathan Dienst )If the table has multiple dimensions, you will need
=Sum(ORDERS)  Above(TOTAL Sum(ORDERS)

Re: calculation  range sum
Jonathan Dienst Oct 28, 2015 5:47 AM (in response to Jonathan Dienst )Assuming Department is the first dimension and date is the second:
=If(Department = Above(TOTAL Department), Sum(ORDERS)  Above(TOTAL Sum(ORDERS), 0)


Re: calculation  range sum
Joanna Seldon Oct 28, 2015 6:11 AM (in response to Jonathan Dienst )Hiya
I get expression error
please help

Re: calculation  range sum
Joanna Seldon Oct 28, 2015 6:24 AM (in response to Joanna Seldon)Hiya
I got it to work with a slight change
Sum(Orders)  rangesum( Above(Sum(Orders)))
I have a number of weeks to show
e.g week 1, week 2, week, 3
I don't wish to show week 1
so chart with show
e.g
5, 12, ect
not
30, 5, 12
how can this be achieved please?
Kind Regards

Re: calculation  range sum
Jonathan Dienst Oct 28, 2015 7:45 AM (in response to Joanna Seldon)=Alt(Sum(Orders)  Above(Sum(Orders)), 0)

Re: calculation  range sum
Joanna Seldon Oct 28, 2015 8:59 AM (in response to Jonathan Dienst )Hiya
this is great
however
I have a customer, that has the value of e. 20
on my line chart he appears as 20, but as soon as you click on customer individually ... he appears as 20
any ideas why please



