sum of the sales

[katragadda]

Hi Friends,

i have a table like following.

customer product salesHeader 3 a apple 100 b mango 50 c apple,mango 200

Now my requirement is i want find the sum of sales  for the product is mango.

Thanks..

[sunny_talwar]

Are you expecting 50 for sales of mango or 250 (200+50)? or some other number?

[sunny_talwar]

If you want 50... try this

Sum({<product = {'mango'}>} sales)

If you want 250, then try this

Sum({<product = {"*mango*"}>} sales)

[PabloTrevisan]

You need a table with the price of each product...
I know that the apple costs 100 and mango 50, so you make a count..

to count the claims and multiply by the value of the unit product

It helps?

[PabloTrevisan]

Prints.

Create a flag to discount apple.

SETANALYSIS :

sum({<flag = {1} >}  salesHeader3)

-

sum({<product = {'apple'}>} price)

[Colin-Albert]

What has been sold to customer C?

200 apples & 200 mangoes

100 apples and 100 mangoes

200 apples & 0 mangoes

0 apples & 200 mangoes

50 apples & 150 mangoes

or some other combination.  Your data does not make this clear.

If customer C has purchased two products, then your data should have 2 lines for customer C listing each product and quantity sold on separate lines.

Is the table you have listed the actual source data?

[nishanthi_8]

To be dynamic, you can go for Sum({<Product={'$(=Product)'}>}SalesHeader3). So if any product is selected it will give the sum of sales as per that product