Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a task. I need to display only customers who have shipped for free, but I also need to see sales for these customers.
The report should look like this:
Help solve this problem
Please provide sample data
I attached the document
Hi Evgen,
Dimension : Client
Expressions :
Sum({<Client=P({<[Transaction Type]={'Free shipping'}>})>} Sales_USD)
Sum({<[Transaction Type]={'Free shipping'}>} quantity)
Regards,
Antonio
Try this?
If(Column(1) <> '0', Sum(sales_usd))
Thank you
script Solution
Data:
LOAD Client,
TransactionType,
quantity,
sales_usd
FROM Table:
left join(Data)
LOAD Client,
sum(sales_usd) as sales_usd_Free
Resident Data
where TransactionType='Free Shipping'
group by Client;
Create chart
Dimension:
Client
Expression
1) Free Shipping
Sum({<TransactionType={'Free Shipping'}>}quantity)
2) Sales_usd
Sum(sales_usd_Free)
For straight table ur Dim will be Client
1st Exp will be
=if(sum({<TrnType={Free}>}quantity)<>0,sum({<TrnType={Free}>}quantity))
2nd Exp..
=if(sum({<TrnType={Free}>}quantity)<>0,sum(sales_usd))