Provide flexibility to select only certain pivoted columns which are relevant to a specific metric on a pivoted table chart.

What is the problem or goal the end user is trying to solve or accomplish?

Currently when you have a pivoted table chart with column values and metrics , no matter if the pivoted column is related to the metric it will try to show all relevant values for it including NULL.

How are they solving it currently?

Not possible using pivoted table.

What is the recommended solution by the Customer?

Provide flexibility to select only certain pivoted columns which are relevant to a specific metric on a pivoted table chart to be shown.