Total value

[smilingjohn]

HI Expertise

Need Help

Please find the attached QVW file..

I have two charts Table A and Table B

Table A works fine with runing total with one dimension which is years and month .

it doesnt work with running total when i add PDSeverity into it.

Please provide some suggestions

If you look at the Table A the It is making the Runing Total ..

When u had PDSeverity into it ..It doesnot perform the Runing total..

Iam looking to get the runing total even if i add PD Severity also ..

If you look in the Tabke A ...for Dec-2015 , Open=9206 and Closed=0

Open-Close= 9206  and this value will be added to Open again and will be subtracted by Close and similarly it follows .

which is working fine when i dont add PDSeverity.

it doesnot work when i add PdSeverity.

It should work even if i add PD Severity ......

...

Tahnks in Advance ..

[sunny_talwar]

May be try this for Running Total expression in thTable B

RangeSum(Above(Sum(PDRunningOpenCount), 0, RowNo()))

[smilingjohn]

HI Sunny

Thanks for the reply ..

Sunny this is not working properly , I mean its not giving accurate result..

When i click on the MOnth Year any one of it.. the values are changing..

[sunny_talwar · Accepted solution]

Was this working in Table A with selection

Try this

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo())) * Avg(1)

[smilingjohn]

Sunny ,

And also i have to include the maximu PdLoadDate for the expression you provided..is this correct way of writing this ?

RangeSum(Above(Sum(<PDLoadDate={"$(=Date(Max({1}PDLoadDate), 'DD-MM-YYYY'))"PDRunningOpenCount), 0, RowNo()))

[sunny_talwar]

My bad, try this

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo())) * Avg(TOTAL 1)

[sunny_talwar]

May be this

RangeSum(Above(Sum({<PDLoadDate = {"$(=Date(Max({1}PDLoadDate), 'DD-MM-YYYY'))"}>} PDRunningOpenCount), 0, RowNo()))

[smilingjohn]

Thanks a lot sunny....

You are the one who really helps everytime during most diffuclt times..Thanks again...

Sunny your expression is working

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo())) * Avg(TOTAL 1)

Can you please take a moment to explain me how it works ?

[sunny_talwar]

1) RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))

Accumulating and ignoring selection in PDReportPeriodB... so regardless of what you select in PDReportPeriodB your chart will show everything

2) Avg(TOTAL 1)

Since we ignored selection in PDReportPeriodB and somehow need to remove the rows which are not selected, we use this expression which will equal to 1 for selections and 0 for out of selection rows.

[smilingjohn]

You are just great