Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have chart A and chart B ...
IN chart a i have clicked on any of the number then it will show me all the months and makes other zero and displays the numbers for that row only
as shown in the chart 1 ..
now i want to replresent this like chart B ..
but here the values are shwing in negative becuase i have taken out PDPeriodMonth from expression..
how do i achieve the chart B with same values and there should not be any negative values.....
Please find the attachment of the QVW file
Thanks in advance
You have used this for OPEN
RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))
and you are saying you don't want to use this?
RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo())) * Avg (1)
The output you want is (when Sept 2016 is selected) only one row with 28 for open and you don't want to see all the other rows? Is that correct? Why do you not want to multiply by Avg(1)? What is the problem there?
Hi Sunny ,
If i do so then i will not see the runing total (OPEN)
for example if you clear everything ,,And look at Feb-2016 the created is 0 and CLosed is also 0
but the Open is 20.. and this is how i want ..
Now if i will use *(avg) 1 then this will not show me the Oepn count when created and Closed are 0 ..
Thats the reason i prefer using this expression
RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))
Then it seems to be a problem of missing data and you need to look at this