Combining two visuals

[aishak12]

All, 

I have two stacked column charts. I want to combine the visuals to plot both values into one chart. It should show two different colors in the new chart.

The SUM value in chart 1 in one color and the SUM value in chart 2 in another color. 

1) 

Label 1,2,3,4 Selected:

2) 

Label 5 Selected:

This is the format of my data:

Column 1)                 Column 2)

Label 1                       10

Label 2                       20

Label 3                       30

Label 4                       25

Label 5                       40

[amitchandak]

@aishak12 , Create a new column

COl3 = Switch( True(),

[Column 1] ="Label 5" , "A", "B")

Use this in small multiples