How can I put 2 bars side by side one for persons A's sales and another one for avg slaes?

How can I put 2 bars side by side one for persons A’s sales and another one for avg slaes ?

Hello @agni_04, welcome to the QuickSight community! I think the best thing to do here would be create a calculated field that calculates the average sales by person. It would look something like this:

avgOver({Sales}, [{Person], PRE_AGG)

Then add that calculated field and the original field with the aggregate “Sum” to your field well with the sales person as the X-axis. That should solve your problem!

1 Like

Hello @agni_04, I will go ahead and mark my response as the solution for now. If something else comes up with this issue, go ahead and post a new topic so it will be back on the top of our list to respond. Good luck!