Immediate months count

[#1]

I want to show next immediate month count and second and third month when DOJ>targetdate...

Please find below attachments...

[Anil_Babu_Samineni]

May be this?

If(DOJ > tagetdate, Sum({<Month = {'$(=AddMonths(Month(Today()),1))'}>}Sales) as nextimmmonth

If(DOJ > tagetdate, Sum({<Month = {'$(=AddMonths(Month(Today()),2))'}>}Sales) as second

If(DOJ > tagetdate, Sum({<Month = {'$(=AddMonths(Month(Today()),3))'}>}Sales) as third

[#3]

Anil, that is already I have tried.. not working...

Anymore suggestions???

[#4]

I want month wise saperate count as I showed in my snap shot

[Anil_Babu_Samineni]

Which snap you are talking about? You attached three images which one we need to look. If possible can you create dummy data and show how you want to look, Please

[avinashelite]

You need this at the script level ?

[#7]

That's my dummy data and my desired output is showed colors with f1,f2 and f3.

Pls suggest

[#8]

I got strucked ...Pls help

[Anil_Babu_Samineni]

Try to create data and show me where you want to do

In your image, I've seen f1+f2+f3

Sum(TOTAL f1) + Sum(TOTAL f2)+ Sum(TOTAL f3)

What are the formula you have for f1, f2, f3. How do you get 38 for f1, 43 for f2, 21 for f3 ???

[#10]

I can't create data now so that I shared my snapshot of desired output.

Pls find this below for your reference.