We analyse our sales over different sourcing methods. In our report we want to show what is sold through the DD sourcing method, and what is sold through the other sourcing methods. In a chart we have two Expressions set up - If ([Sourcing Method] = 'DD', Sum([Line Value])) and If ([Sourcing Method] <> 'DD', Sum([Line Value])).
When selecting either sourcing method the line value for this is shown under the right heading. However, when selecting both Sourcing Methods both figures are shown in the Other Sourcing method total - none is shown under DD.