Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Three different measure field to be summed up to till date where ever the Closed field flagged as '0'
Data example :
Date field Measure1 Measure2 Measure3 Closed
01/02/2016 1000 1000 1000 1
01/03/2016 1000 1000 1000 1
01/04/2016 1000 1000 1000 0
01/05/2016 1000 1000 1000 0
01/06/2016 1000 1000 1000 0
Regards,
Jegadeesan G
Try this from preceding load
Or use expression
Dim is date field
And expression is
Sum({<date = {'<=' & '$(=len(closed)>=0)'}>} (measure1+measure2+measure3))
In terms of numbers, what is the expected output and also in what object?
Hi Sunny,
Object is pie chart. I have to show share of Demand and Collection. Given above table is for Demand calculation. The table for collection calculation also same as Demand but I didnt give that here...
Hi Jegadeesan,
Assuming you have DateField as the dimension, Could you please try out below expression?
Sum({<Closed={'0'}, DateField={'<=$(=max(DateField))'}>} Measure1 + Measure2 + Measure3)
Hope this helps.
It would be great if you can share the qvw containing this issue. That will help me understand the problem in a better way.
Thank,
Akash.
IE version 10