Previous Month

[SkinkUSA]

Hi there, I am new to Qlik and have a very simple table I am working on. My question is, in the table below, how would I have the second visit volume column show the previous month volume? So if I was filtered for June for example, how could I get the second column to show May? Thanks in advance.

Visit Type   MonthYear   Visit Volume   Visit Volume

Flu Shot     June                10                    ?

Nurse Visit June                15                    ?

[TimvB]

The following function will set the field MonthYear to last month:

Sum({$<MonthYear = {$(=Month(AddMonths(Max(Date),-1)))}>} [Visit Volume])