Showing sum() values

[Vijay87]

QlikView/QlikSense

ProductName	ProductSales
A	50
B	60
C	100
A	20
D	80
B	120
E	40

I have table,  ProductName and ProductSales. Here repeated Productname I have, in front end I would I show the ProductSales A=70(50+20), B=180(120+60).

Your response and support give me strength and courage.

Thanks for the Advance. 

[Marijn]

Hi @Vijay87

Create a chart in qlikview, choose the straight table. Use only ProductName as dimension, then create an expression with sum(ProductSales). That should do the trick.

Regards,

Marijn