Pivot Tables

Hi there,

I'm currently creating a dashboard and as part of this I've created a pivot table based on one regular table (which houses all my data) to make the dashboard easier to update.

The aim of the pivot table is to showcase a variety of different metrics in the rows section, with years (e.g. 2014, 2015, 2017 etc) across the top in the columns, and then each corresponding metric's value in the core of the table, with the whole table being controlled by slicers.

I'm running in to issues when pulling in the values, as I need the pivot table to sum up different values depending on the metric in the row column, however whenever I add in a different 'sum value' to the values section, the table also adds it in to the columns section and distorts it.

Is it possible to have the pivot table sum up different values depending on the metric in the row column without altering the columns headings (i.e. years), or creating a different pivot table for each metric (there are over 50 so would rather not do this)?

Also, if I add a slicer to control which metric is shown, is it possible to make the pivot bring back the different data depending on which metric is selected?

Thanks

Steve