Extending Dimension to Second table

[balajiqlikuser]

Hi all,

I have two tables T1 and T2. I have joined them with Year month of Date D1 in T1 with Year month of Date D2 in T2. Now i need to build a chart to see the daily trends. My Dimension is Day(D1) and my expression is sum(Sales1 in T1)/sum(Sales2 in T2). But when i do this, the numerator is grouped by the Day(D1) whereas the denominator is not grouped by Day(D2). I want it to be Day(D1) = Day(D2) for calculating the daily metrics. Any idea on how to achieve this? 

Thanks!

[edwin]

not knowing the columns, peripheral dimensions of both tables, or the data model in general, i would say find a way to concatenate these two tables and have just one date and 2 measures.  or can you link them together by renaming one of the dates so they are the same.  it sounds like they are linked by date anyway.  otherwise create a link table if there are more than just one field that relates them

[Kushal_Chawda]

@balajiqlikuser  Why don't you just join them based on Date in T1 & Date in T2 instead of year month?