Chart Expression

[#1]

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.

[erichshiino · Accepted solution]

What happens when you include the sourcing method as a dimension on your chart? Then you could avoid the if-condition.

another option would set-analysis.

Try these:

Sum( {<[Sourcing Method]*={DD}>}  [Line Value] )

Sum( {<[Sourcing Method]=[Sourcing Method]-{DD}>}  [Line Value] )

Hope it helps,

Erich

[#3]

Thanks for that. However using your suggestion if I select the sourcing methods other than DD there are no figures where I know there should be.

I didn't have the Sourcing Method in the Dimensions but if I do the suggestion still doesn't give the results.

Ian

[erichshiino]

Hi,

I don't understand why it didn't work.

Please, check my attachment (I may have misunderstood your problem)

Regards,

Erich

[rahulgupta]

Hey hi,

Kindly find the attached file...

Hope this find your solution....

[#6]

I tried this again at it works. Thanks

[rahulgupta]

My Pleasure....!!

[#8]

What happens when you include the sourcing method as a dimension on your chart? Then you could avoid the if-condition.