Display sales by customers who made free shipments

[kolov007]

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

[Anil_Babu_Samineni]

Please provide sample data

[kolov007]

I attached the document

[antoniotiman]

Hi Evgen,

Dimension : Client

Expressions :

Sum({<Client=P({<[Transaction Type]={'Free shipping'}>})>} Sales_USD)

Sum({<[Transaction Type]={'Free shipping'}>} quantity)

Regards,

Antonio

[Anil_Babu_Samineni]

Try this?

If(Column(1) <> '0', Sum(sales_usd))

[kolov007]

Thank you

[Kushal_Chawda]

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)

[suhaskharat]

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))