No. It will not work out.
I have a cost % for each sub-category as shown and should filter the data based on Region & Market filters only, not from Customer Name.
Display Cost % at each customer & Region & Market Filters as shown:
Now I want to merge above charts in side-by side bars.
When there is any change in the customer name filter, then green bar alone(based on data not the blue bar) should change. When there is any selection in Region/Market, then both bars(blue & green should change respectively.
Also wanted to display % difference between blue and green bars for same sub-category.
Ex: Labels: Overall it has 12.68% & at customer level it has 15.93% which means that there is an increase of 3.25%(output)
I Hope it is clear.
I am wondering if this is possible in Tableau. Do I have any good news?