Script

[smilingjohn]

HI All

Please find the attachment of the qvw and the excel sheet ...

Can please anyone sugest me how do i achieve this ?

1.need to plot a bar chart

Report should display only data of selected month and prior 11 months prior to the current month

For example

On selection of Dec 2014 , report should display from Jan 2014 to Dec 2014

Total = (Total from last month (if not there consider 0) + Open  based on the Status for current month) -Closed based on the Status for the current month

Example :

For Jan 2015

Total for Dec 2014  = -247

Opening for Jan 2015 = 17

Closing for Jan 2015 = 36

Total for Jan2015  = (Total for Dec 2014  + Opening for Jan 2015)  - Closing for Jan 2015

i.e. (-247 + 17) -36

Thanks in advance

[Anil_Babu_Samineni]

You missed attaching, Will you?

[smilingjohn]

Hi Anil

I have attached them please check ....

Thanks

[Anil_Babu_Samineni]

Look here? Change accordingly as you require the data points

I change script for your MonthYear field like

Date(Date#(MonthYear, 'MMM-YYYY'),'MMM-YYYY') as MonthYear

I used this expression in straight object

Count({<MonthYear = {">=$(=Date(YearStart(MonthYear),'MMM-YYYY')) <=$(=Max(MonthYear))"}>}Open)