How to do?

[irmantas]

Hello,

I am new here, and have interesting report for me.

Exp.

Client     Product     QTY

C1          P1               1

C1          P2               1

C1          P3               1

C2          P2               1

C2          P3               1

C3          P1               1

C3          P2               1

I need create report, about Product P1 by Client, but want to know about anther products for the clients hue buy product P1

report must be some like this:

Client     Total QTY(P1)     Total QTY (P2)     Total QTY (P3)

C1                    1                         1                         1

C3                    1                         1                         0

I now need Client C2, because he didn't buy product P1.

How to do it?

[Mark_Little]

Have the client as your dimension.

Then three expressions

SUM({<Product={'P1'}>}QTY)

If(SUM({<Product={'P1'}>}QTY)>0,SUM({<Product={'P2'}>}QTY))

IF(SUM({<Product={'P1'}>}QTY)>0,SUM({<Product={'P3'}>}QTY))

Mark

[richard_chilvers]

I think a good start is to use a Chart, with the Straight Table style.

Use Client and Product as Dimensions and use SUM(QTY) as the expression.

See how it looks. You can play with the formatting and may like to change to a Pivot Table later.

HTH

[HirisH_V7]

Hi,

Expressions for chart :

Sum({<Product={'P1'}>}QTY)

Sum({<Product={'P2'}>}QTY)

Sum({<Product={'P3'}>}QTY)

PFA....

Hope this Helps!

Cheers,

HirisH

[irmantas]

Thank you for all.

[oknotsen]

If your question is answered, please flagged the Correct Answer.