I'm not entirely sure I get exactly what kind of end result you're looking to see. Your calculations sound correct overall. But I do wonder what you're trying to accomplish with your column name calculation. If you are showing all months from 2012-2013, where half are Sales and the other half are Forecasted Sales, what do you want the column heading to be? You likely don't need a column name header at all - just name the Measure calculation selecting the appropriate Sales an acceptable column name.
See the attached sample workbook and let me know if this is what you're looking for. Otherwise, can you share a workbook or even an Excel mockup showing what you'd like your final view to look like, and I will take a look.
But hopefully this helps!
SalesOrForecast.twbx.zip 52.7 KB
Yes, your example has the basic idea in place. Especially in the single select area.
However its another step more complicated with the name portions. I see the same sort of issue when we expand to look at "All" Months, which is what Duplicate Columns also shows. It involves labeling the "sales selection" properly when it shows one or the other sales figure.
I have attached an example of how the original report from BO works out. I can definitely go by and just put a label that shows that we can have values of either, but in the original reporting software I had been able to arrange for it to change with the data/time as well.
I thank you for your assistance. I realized my data extract to work on this trial has a flaw and I have to redo it before I test/recreate some other aspects of the original report...
Book4.xlsx 11.8 KB