Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Need Help??

Hi Community,

Calculate Sales history by month for last six month.

Thanks..

5 Replies
venkatg6759
Creator III
Creator III

sum({<month={'>=$(=monthstart(addmonths(today(),-6)))'}>}Sales)

qv_testing
Specialist II
Specialist II
Author

Hi Venkat,

it's not working. i want based on current selection.

suppose if i am click Dec2013,  i want to show last 6 months...

MK_QSL
MVP
MVP

what is you selection format?

It is MMM or MMMYYYY or MMMYY or...???

venkatg6759
Creator III
Creator III

Check the sample attachment

Not applicable

instead of today you can use max(month).