Tableau Prep Builder, allows limited multirow calculations. This can be helpful during the data preparation step. The details can be found in this post.
How to Achieve it:
Following calculations are currently possible in Tableau Prep Builder:
Computes the difference between the current row value and another value.
Percent difference from:
Computes the difference between the current row value and another value as a percentage.
Returns the sum or average of a numeric field within a flexible set of rows.
Using an example, let us see the steps involved in performing a multirow calculation.
Connect the data to Tableau Prep Builder. Add a “Clean Step” to the flow, and here we can add a new field (eg. Percent difference from previous value) based on multi row level calculation as shown below.
A popup window will appear as shown below, here users can define the nature of the calculation. Finally click “Done” button to save the new calculation and continue data processing.
Tableau Prep Builder started supporting multirow calculations, this can be of some help during the data processing step.