Month restriction based on Bucket selection

[Anonymous]

Hi All,

   I am having 2 fields (Fore Cast Month,Bucket). Here I need to show the month & For Cast Values in the chart based on selections of Fore Cast & Bucket

For Ex  If I select "Jan 2017"  in Fore Cast Month and "3+Months" in the Bucket I need to show the values starting from Jan 2017 to Mar 2017. Same way if I select May 2017 and 6+ Months the chart should show the Fore Cast values from May 2017 to Oct 2017.

Please let me know if there is query

-Jai

[Anonymous]

++ Atatchment

[tyagishaila]

yes you can do it by using addmonths()

=If(Bucket='3+Months', Date(Addmonths(MonthStart(Date(Date#([Fore Cast Month],'MMM YYYY')) ),3),'MMM YYYY'))

[Anonymous]

Hi Shaila,

I am not getting the expected result. Could you help me on this?

-Jai

[Anonymous]

Hi All,

Any idea on the above?

- Jai

[tyagishaila]

Share qvw sample.

[Anonymous]

++ QVW

[ElizaF]

Hi,

See another solution in attach file. I used Set Analysis function and I thing it cover your request.

Another solution is to use AsOfTable Concept.

I do not recommend the above function because it is consuming resources in the UI.

[Frank_Hartmann]

See attached file.

hope this helps