Need help with "Or" Function

[#1]

I have this formula below , where the value is not affected when I select a “National Account”

Sum({<[National Account] => }  [QTYBACKORD])

I want to expand the formula and also include “Customer Group” , “Customer” and “Customer Code” .  I’ve tried different formulas but with no success.  Below is the last formula I tried.

Sum({<[National Account] => }  [QTYBACKORD]) or

Sum({<[Customer Group] => }  [QTYBACKORD]) or

Sum({<[Customer] => }  [QTYBACKORD]) or

Sum({<[Customer Code] => }  [QTYBACKORD])

Can you tell me where im going wrong.

kind regards

Nayan

[jagan · Accepted solution]

Hi,

Try like this

Sum({<[National Account] =>   + <[Customer Group] => +
<[Customer] => +

<[National Account] => +
<[Customer Code] =>}
[QTYBACKORD])

Regards,

Jagan.

[#3]

Hi Jagan

It works .  Thank you 

regards

Nayan