Can I use a date formula with secondary dimensionality in my expression?

[#1]

I have a horizontal expression that sums across the rows for a Total number and then within that same Total column, I have another formula for the % of the "Joe and John's" divided by the Total.  The below formula works great to accomplish this. 

What I would like to do is add a date function to this formula ...  I want to be able to manipulate this date function so that I can get today's or yesterday's data. I'm just not sure where the date part goes in the below:

=

If(SecondaryDimensionality()=0,

Sum(IncludeComp) & ' (' &

Num(Sum({<Carrier = {'Joe','John'}>}IncludeComp) /Sum( IncludeComp),'#.00%','.',',')

& ')',

Sum(IncludeComp)

)

[sunny_talwar]

Awesome , I am glad it all worked in the end