1 of 1 people found this helpful
I just watched a great video explaining this. You started off correctly by creating a parameter. Next, you want to create a calculated field that will get the previous month's profit ratio:
When you add it to the viz, change to "Compute using: Order Date"
Next, you can see that the formula is working correctly.
Next, you want to create a TF calculated field that filters to show only the month selected in the parameter.
Add to the Filter shelf and select "True", and you're done. By using the TF calculated field, the Prev. Month Profit Ratio value is still maintained.
However, you'll note that Esbjerg and Graz didn't have any sales last month, so a null value is showing up for Prev. Month Profit Ratio.
Hope this helps!
Walt. Brilliant. Thank you so much.