yay!!

You can alias a measure in a calc:

With [Measures.[Yesterday Clicks] as

(

[Measures].[Click Count]

)

That's going to cause you problems though, if you want to show both today's and yesterday's clicks on the same dataset. Then you would need to include a date modification in the measure, somewhat like

With [Measures.[Yesterday Clicks] as

(

[Measures].[Click Count], [Date Dimension].[Date].currentmember.prevmember

)

Then you would be able to use today's date directly as a dimension in the rows, without it calculating to yesterday. My syntax there might need correcting.

[Edit] actually I think what I've shown there is wrong but that's the general idea. Let me know if you want to do something like that and I'll post how.