Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
i have a table like following.
|
Now my requirement is i want find the sum of sales for the product is mango.
Thanks..
Are you expecting 50 for sales of mango or 250 (200+50)? or some other number?
If you want 50... try this
Sum({<product = {'mango'}>} sales)
If you want 250, then try this
Sum({<product = {"*mango*"}>} sales)
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?
Prints.
Create a flag to discount apple.
SETANALYSIS :
sum({<flag = {1} >} salesHeader3)
-
sum({<product = {'apple'}>} price)
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?
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