Total costs for latest month

[#1]

Per attached file I want to show the monthly costs column ie the total for the latest month.

At the moment I have data for Jun - Dec 2014. So that column would need to show the data for latest month in this case December.

Thanks in advance

[saurabh5]

hi Sid_Smith,

you can do a set analysis and create an expression as:

=sum({<datefield={"=$(=max(month(datefield)))"}>}expenses)

[#3]

Unfortunately it's giving me a total aggregated amount for all months as opposed to just december. My expression is

=sum({<[Booking Date]={"=$(=max(month([Booking Date])))"}>}[Account Excl VAT])

[robert_mika]

The attached data does not match your expression

[#5]

So Booking Date is the date field and Account Excl VAT is the sales amount

[robert_mika]

Could you check the file?

And if you will attached another one is better to attached in Excel file.

[manojkulkarni]

Use 2 variables

set

st_date=

date(monthstart(Max(billDate)),'YYYY-MM-DD');

set

en_date=

date(monthend(Max(billDate)),'YYYY-MM-DD');

= sum({<bill_date={">=$(=st_date) <=$(=en_date)"}>}sales)

[#8]

Manoj - These expressions work - but again they give me an aggregated sales amount for all the months as opposed to just the latest month.