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?
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
