Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi Sid_Smith,
you can do a set analysis and create an expression as:
=sum({<datefield={"=$(=max(month(datefield)))"}>}expenses)
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])
The attached data does not match your expression
So Booking Date is the date field and Account Excl VAT is the sales amount
Could you check the file?
And if you will attached another one is better to attached in Excel file.
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)
Manoj - These expressions work - but again they give me an aggregated sales amount for all the months as opposed to just the latest month.