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