I noticed in the pivot table report, there are a plethora of functions such as % of total, % difference and so on that is available for reporting.

However, the very same metric functions are not available in charts. I have attached a screenshot of a pivot table showing % of region sales out of total sales. It would be great to use graph, other than PIE charts, visualize the breakdown. For instance stacked bar graphs.

The use of % functions or even sales by a dimension such as region over total sales is very useful when building comparative/nominal charts.

Am I missing something in the chart function to provide this functionality or is it just not there?

Cheers

Sunil