This can be done. First, you'll need to place Week(Load Date) on the rows shelf as well.
Then, place Product on the view. Right click and select Quick Table Calculation...>Percent Difference. Right click again and select Edit Table Calculation. Select Advanced...>Place Year, Month then Day of Load Date in the addressing box. Click OK. Choose Deepest for at the level and Restarting Every: None. This is for the Daily Percent Difference.
For Weekly, place another instance of Product on the view. Follow the same instructions as above, only place Week, then Day, Month and Year of Load Date into the Addressing box. Choose Week of Load Date for At the level and none for restarting every.
Finally, for Monthly, follow the same instructions. Choose Load Date for the Compute Using, Month of Load Date for at the level and None for restarting every.
From here, if you'd like to rename them all, edit each calculation. Then, click Edit Formula... in the dialog box--a calculated field will appear. Simply rename the calculation and click OK, OK.
Hope this helps!
I attempted to set this up based on Tracy's instructions. You will say NULL values where there is no difference to compute. Otherwise, the instructions were pretty much spot on.
percent difference ML.twbx 24.0 KB
Great, this works perfect.
Thank you so much for the help!