Hi Everyone - I'm starting to delve into how to best use Analytics for dynamic pricing, and wanted to start with a pivot table that shows how much revenue we've gained with dynamic pricing and lost through discounting. I'm new to this, and want to make sure I'm getting the basics right. For the +/- Revenue column I used "[Total Variance to Order Date Base Value]". Screenshot below.
If anyone can let me know if I'm on the right track, I'd appreciate it. Thank you!
I answered my own question today.