An Excel Table is used for sensitivity analysis (investment vs discount rate)

In another project, we have the expenses breakdown for a company

A Pivot Table is created where amounts are aggregated by date (grouped in months) and categories

Some rearrangement and formatting

Labels are expandable, so higher level of granularity can be seen

Currency can be filtered to only CAD

Product Line may also be filtered

Category may also be filtered

Date (months) may also be filtered.

We also may create a calculated field to calculate Amount in EUR based on conversion ration between CAD/USD and EUR

By adding slicers, the categories may be filtered

Similar slicers may be used for Product Line

Timeline may also be added for Date