Dear Experts,
Is there a way we can achieve the following ? :
The table goes by Report Date(transaction date) as the dimension and the measures are to be the sales on that day(row) and the sales of previous month on same day. So for an example, the first row we see below is 20/4/2016 which carries its value in column sales, in column sales last month, we are expecting the sales of 20/3/2016. Is this possible in a table that carries the date itself as the dimension? I know it is possible with any other dimension, but this case is tricky to solve.
Kindly Help.
Thanks 🙂