I want to have the sum by customer for a product without customer in dimension

[Touix]

yone,

I ask the Qlikview expert to help me about a simple problematic I have.

I have this data  and i want to have the sum of the data per article but i just want to show the article.

Facture Number, Article, customer_id, amount

F1,Pen, 10,10€

F2,Pen,10,10€

F3,Pen,12,12€

F4,Pencil,10,13€

F4,Pencil,10,13€

F5,Pencil,11,14€

result :

Pen,20€

Pen,12€

Pencil, 26€

Pencil, 14€

I cannot see how to do this 😞 .

thank you for your help.

Regards,

[Taoufiq_Zarra]

you can use =sum(aggr( sum(amount),customer_id,Article))

as measure

and Article, customer_id as dimension

and hide customer_id dimension

[Touix]

Hello taoufik,

Can you tell me how to hide a dimension please ?

[Taoufiq_Zarra · Accepted solution]

@Touix  if you are in qliksense no need to hide dimension:

you can add table and

in dimension:

Article

in an other dimension use :

=aggr( sum(amount),customer_id,Article)

output:

[Touix]

Thank you very much Taoufik.

You helped me a lot.