In this guide, we will wrap up our work on the interactive report by exporting and setting up the OPEX table in the form of a Pivot Table, pulling data using filters, and calculating key financial metrics such as Net Revenue, Losses, and EBITDA.

In this chapter, we use the SUM, GETPIVOTDATA, and LEFT functions.