Get the Total Qty bought per item

[fgirardin]

Hello !

I created a sales report that contains data from our ERP

It shows customer, item purchased, price, qty, ...

My table looks like this:

DATE     CUSTOMER     INVOICE N°     ITEM     QTY     UNIT PRICE     TOTAL

1               A                                               iA           5                 1                    5

2               B                                               iA           2                1                     2

3               A                                                iB          4                10                    40

4               B                                               iA          10               1                    10

I can select a specific customer, a specific date or a specific item and I get the sales for a specific date

I'd like to be able, when selecting a customer, to have the total qty bought for each item

So it would look like something like this:

CUSTOMER     ITEM     TOTAL QTY

A                         iA               5

A                         iB               4

B                         iA               12

Any help is appreciated.
Let me know if my question don't make sense !

Thank you

[Anil_Babu_Samineni · Accepted solution]

you don't need any thing here

Create straight table

Dim - CUSTOMER, ITEM

Measure - Sum(QTY)

[devarasu07]

Hi,

like this? if  not what is the logic to derive Total Qty?

=sum(QTY)/(UNIT_PRICE)