Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
Hi,
I don't understand why it didn't work.
Please, check my attachment (I may have misunderstood your problem)
Regards,
Erich
Hey hi,
Kindly find the attached file...
Hope this find your solution....
I tried this again at it works. Thanks
My Pleasure....!!
What happens when you include the sourcing method as a dimension on your chart? Then you could avoid the if-condition.