Pie Chart

[evansabres]

Hello -

I would like to create a pie chart to show sales by different product type.

My dimension is [Major Group] under which there are items such as Food, Beer, Wine, Liquor.

I want to create a pie chart that gives the percentage of overall sales (That dimension is called [Sales Total]

As the different items are not named in the script, what is the best way to do this?

Thank you.

[sunny_talwar · Accepted solution]

I think if you add [Major Group] as dimension and Sum([Sales Total]) as expression and select relative, you should get what you are looking for.