Add Percent of Total and Total Sales Value for Each Data Level Available in the Bar Chart

Hi Team,

I want to add two metrics for each bar chart data level. In my dashboard, I would like to display the Percent of Total Sales and the Total Sales value for the respective data level. However, I am unable to do this and I am getting an error.

Pic -1 : With only one measure

**Pic 2 : An error occurs when I try to add the Total Sales Value metric

Pic 3: Desired Results (Here you can see both Total Sales and Percent of Total Sales on each Subcategory Level)

Thanks & Regards
Biswajit Dash

Hi @Biswajit_1993,

You can’t do this in Quick Sight. You have to choose the primary measure that you want display in the bar chart and add the other one as a tooltip.

1 Like

Hi @David_Wong ,

Thanks for the information.

Thanks & Regards
Biswajit Dash