Filtering for just one month in a table

[#1]

Hi,

On my dashobard I have a years worth of data on various tables and charts, however for one part of the dashboard i just want to be able to show the previous months month end figures, doesnt matter what filters are used, it just always needs to show last month.

I have a box for total patients, total waiting over 18 weeks and % compliance. An example of my calcualtion/formular is:

= sum({$<Metric_Part={'Den'}, Metric_Code={'RTT15'}>} Metric_Value)

What would i change to make it show just last month and not the whole year as a total?

Thanks,

[ramoncova06]

= sum({$<Metric_Part={'Den'}, Metric_Code={'RTT15'}, Date = "$(=date(floor(monthend(max(Month),-1))))"}>} Metric_Value)

this will give you the for month end of the previous month

[#3]

Thanks – its giving me an error though. Do I need to change anything in the below formula? Like ‘Date’ does that need to be one of our date fields?

Kate Hunter

Senior Information Analyst

Planned Care Team

Derby Hospitals NHS Foundation Trust

Level 5

Tel: 01332 786745

Ext: 86745