Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya
I want to show difference for each department - per week
I have this calculation
rangesum( above( sum(ORDERS),0,rowno()))
its adding up the rows...I wish to show difference
e.g
week 1 = 30
week 2 = 35
difference is 5
Please help
For difference you just need:
=Sum(ORDERS) - Above(Sum(ORDERS)
For difference you just need:
=Sum(ORDERS) - Above(Sum(ORDERS)
If the table has multiple dimensions, you will need
=Sum(ORDERS) - Above(TOTAL Sum(ORDERS)
Assuming Department is the first dimension and date is the second:
=If(Department = Above(TOTAL Department), Sum(ORDERS) - Above(TOTAL Sum(ORDERS), 0)
Hiya
I get expression error
please help
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
=Alt(Sum(Orders) - Above(Sum(Orders)), 0)
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