How to get the previous month count

[#1]

How to get the previous month count, as per attached example need the previous month (Mar’15) count in current month (Apr’16) for the same department

Please Help. Thanks in advance

[#2]

I am still not able to get correct values. Need Mar'15 values in Apr'16 for the specific department.

Please help. Thanks for your effort and time.

[sunny_talwar]

Last years previous values?

[#4]

Hi Sunny,

Absolutely right. Please help with the same.Thanks

[pho3nix90]

The solutions thus far is to use inter record functions within the chart, it seems you are using a financial calendar and thus year starts on April, to show the previous value for April you will need to display March in the table as well for the current solutions.

What you need is for the calculations to be done in script. Please upload the "Tes.xlsx" so that I can give you another example.

[#6]

Hi Shaun,

You are right. Please find the attached excel data for your reference.

Thanks for your support.

[pho3nix90 · Accepted solution]

Please see attached