how could I give the red bars different colors in the bar, depending on an other field
Go to your expression, clic on [+] icon to expand, and edit the background color, like this:
=if(sum(Sales)>0, rgb(0,183,0), rgb(194,0,0))
In the Chart Properties on the expression for the bar expand the +to the left of it and enter your required expression for back ground with something like :
if ( [YouDim] = 'A' , Blue() , Yellow() )
Not exactly what I tought, it has to be a sort of stacked bars and the Kontr-stplts depends the colour of the bar
Go to your expression. Click on the + symbol and give the condition for the color in the Background Color option.
This might prove useful:
Retrieving data ...