Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show next immediate month count and second and third month when DOJ>targetdate...
Please find below attachments...
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
Anil, that is already I have tried.. not working...
Anymore suggestions???
I want month wise saperate count as I showed in my snap shot
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
You need this at the script level ?
That's my dummy data and my desired output is showed colors with f1,f2 and f3.
Pls suggest
I got strucked ...Pls help
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 ???
I can't create data now so that I shared my snapshot of desired output.
Pls find this below for your reference.