Hi,
Many of my users have asked for a way of selecting "Month to date" that can remain in place without having to physically change the month in a date hierarchy. I came up with a way of doing it by creating a pseudocolumn "Current Month" which shows a "Y" if it matches today's month and an N for all other rows. This has worked effectively, however now i am being asked if it could show "Month YYYY" as opposed to the "Y".
My issue with this is having a default member auto selected in a filtered dimension. I am not sure if this is possible.
I have tried setting a current month dimension member to non aggregateable and then forcing a default member, but that is global without even selecting anything.
Can anybody think of any other way of making the field automatically select when filtered? (Obviously this is necessary because if it says March, and then when it turns into April the data changes and the selection cancels).
Hoping somebody has an idea!
thanks