sum value field

[#1]

Hi,

I have some values and within a table.

I want to make a chart with a column per value in valuename I guess it can be doen with expressions. How do I sum a value field with expression Commission invoice in ValueName.

Commission invoice   | Commision rebate  | Commission Total
_________________  |________________ |_________________

1                              | 10                        | 14

2                              | 12                        | 14

3                              | 14                        | 14

[PradeepReddy]

can you share sample application?

[jonathandienst]

It can, but what is the actual fieldname or expression associated with Commission|Invoice?

If you post your qvw or a representative sample, you will get more specific and more accurate help.

[rajeshforqlikvi]

Hi,

you can do this by set analysis or if condition like below:

By If condition:

If(valueName ='Commission invoice ', sum(valueName ),

if(valueName ='Commision rebate',sum(valueName ),

  if(valueName ='Commission Total',sum(valueName ))))

By set Analysis:

sum(<valueName ={'Commission invoice '}>valueName )  for this take a list box and write this exp in the expression in list box same way for all just check the syntax properly.