Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have the following issue: I am trying to get a sum of revenue per customer per year, but only for years that the customer has exceeded a predetermined sum of of revenue for that year.
eg:
aa 2015 100
bb 2013 50
cc 2015 110
aa 2015 80
bb 2014 40
cc 2015 90
bb 2014 70
show customer data only when yearly sum over 100
result WITHOUT the condition
aa 2015 180
bb 2013 50
bb 2014 110
cc 2015 200
result WITH the condition
aa 2015 180
bb 2014 110
cc 2015 200
So far I am unable to solve it. Any ideas?
Thank you
May be this? Attached the qvw
Data:
LOAD *,
rowno() as Row
FROM Data
Create straight table
Dimension:
Category
Year
Expression:
1) Without condition
=sum(Revenue)
2) With condition
=sum({<Row={"=sum(Revenue)>100"}>}Revenue)
HI,
DIm : ID,Year
without condition Expr :
Sum(Value)
with condition
If(Sum(TOTAL <ID,Year> Value) > 100,Sum(Value))
egards,
Antonio
try this
If (Sum(A)>100,sum(A))
can you share the condition please