Thank you for the very detailed explanation Craig! That is exactly what I need. That pivot query was very, VERY helpful. I was able to see how when I added up the Value in PeriodTypes where the bit was "set", I could come up with the PeriodType value in Reports. So I added 65536 to the "Overall Performance" row in Reports and now I see "Calendar - Year To Date" as one of the options!! I am so grateful for this forum and contributors such as yourself!