This workflow walks walks a user through how to use the multi-row tools to prep tiered usage charge data. This logic could also be applied to other scenarios, such as tiered pricing or tiered tax brackets (ex: United States federal tax rates).
Use a multi row tool to calculate the running total value of each tier, then use a multi row tool to calculate the tiered discount that should be applied to the dollars in each tier.
Want to read the blog post? Check out Lovelytics blog here. Want to follow along with a step-by-step video? You can watch the video tutorial here.