Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi James,
Create dimensions for Day and Name fields.
After that, edit the Name dimension for giving colors to the values of that field.
Create a measure for Amount EUR field and the expression should be : Sum(IF(Name='Cash Out',-1,1)*Amount EUR)
After creating the bar chart and adding your dimensions and measure, go the measure properties of charts and make the modifications.
Change your bar chart appearance to stacked and it should be as you want.
Hope it helps...
View solution in original post