One of the little known possibilities are the row based calculations in a pivot table. Let's start with a simple report based on the sales sample RPD:
From this base report we make a simple pivot table:
In the columns section click on the column properties and select "New Calculated Item"
Now can create a rowbased calculation:
You can also play with the other functions:
Till Next Time