Hello,
I have all my dates in a dimension called MonthYr. I'm comparing YOY for my firm and industry. On the tooltip I want to see how we did last year same month and this year same month.
Again, I want to see the total of industry and my company on the tooltip.
Let's say, I hover on March, 2017 sales, I want to hover to look like this:
March, 2016 : 797966
March, 2017: 32537568
Likewise for industry and my company.
The dimension I'm working with is MonthYr. It has 2 years data.
Measures are Sum(industry) and Sum(Sales).
I want to extract, month, year sale data compared to industry and also with our sales.
I've created a workbook with Sample Data. When I hover over Nov, 2013 profit, I would like to see the profit amount for Nov, 2012 we well.
Please help.
1. Create a calculated field like this. The assumption made in this is that you will have data for every month and that there are no missing months from the first period. If however you think that there will be missing months, then the calculation needs to change.
2. Place the above field in the Detail marks and display on the tooltip.
