Forecast Probability for the next 30 days

[wildtopiwala]

Hello Everyone

I have a Point Chart based on a OLAP. I would like to show the probability that how many deals will close in the next 30 days.

Is there a calculation that I need to apply or filter? Do you know what that calculation will be.

I have a Opportunity Amount as a measure, Probability as a Dimension and series as a State.

I will greatly appreciate your help.

[BigChris]

I think we would need a little more information than that. Is the Probability that you've got at the moment the probability that any given opportunity will close? If it is then I would imagine that you'd be interested in the (Probability * Number of Opportunities)

[wildtopiwala]

Yes, that is correct.
For each client, there is a probability based on 7 different stages. Attach please find a sample spreadsheet to better understand.

Thanks

[BigChris]

OK - I'm still not clear what you're trying to get to. Based on your data, are you expecting a value of 3.05? That's "expected" number of opportunities that will be won. Or are you looking for 4,915.5 which is the sum(probability * amount). If you can define what you're trying to get to, we can help you get there.

[wildtopiwala]

I think I was making it over complicated. Can someone please tell me how to add a filter to get record to for the next 90 days.
Its an olap cube.

here is what I am using and it is error out:
intersect(lastPeriods(-9999, #'[myCube].[fiscal Date].[fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask($current_timestamp,'yyyymmdd') +']'#), lastPeriods(9999, #'[mycube].[fiscal Date].[Fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask(_add_days($current_timestamp,90),'yyyymmdd') +']'#))

Thanks in advance  :) :) :)

[MFGF]

I think I was making it over complicated. Can someone please tell me how to add a filter to get record to for the next 90 days.
Its an olap cube.

here is what I am using and it is error out:
intersect(lastPeriods(-9999, #'[myCube].[fiscal Date].[fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask($current_timestamp,'yyyymmdd') +']'#), lastPeriods(9999, #'[mycube].[fiscal Date].[Fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask(_add_days($current_timestamp,90),'yyyymmdd') +']'#))

Thanks in advance  :) :) :)

How about:

lastPeriods(91, #'[myCube].[fiscal Date].[fiscal Date].[Day]->:[PC].[@MEMBER].[' + timestampMask(_add_days($current_timestamp, 90),'yyyymmdd') + ']'#)

As I mentioned before, you should not use detail filters with dimensional sources. This would either be a query calculation in your report to display the members, or it would be a slicer member set in a slicer filter in your query (depending whether you want to see the members or just change the context of the measures for these members).

MF.