All - I am trying to get set analysis to give me all 3 mos in any given quarter, no matter what month is selected in a given range...
I have been using
sum
({$<Year = {$(=max(Year))}, Quarter = {$(=MaxString({<Year={$(=max(Year))}>} Quarter))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} Goal
)
But this only gives you the max mos for the selected range, ie if you select may and june you would have 2 mos in your result not the 3
For example, if you have 2009 selected, and select the month of March, you should obtain Jan, Feb and March or Q1 as a result. If you select Jan, Feb, Mar Apri, you should expect to see (April May and June) or Q2
If you select Sep, Oct and Nov, you should expect to see Oct, Nov and Dec or Q4...
