Formula Question

[#1]

Hello!  I have a document loaded into Qlikview.  I need to sum inventory by store by SKU number.  when I use the formula =sum(inventory) in the expressions is sums all the inventory for the whole company and says that is what each store has on hand.  which I know is not correct.  Any ideas on what I should try?  the document looks like this:

Store Name:                              On Hand                            SKU

Store Number 1                         4                                        123456

Store Number 2                         7                                        123456

Store Number 3                         6                                        123456  

Store Number 1                         8                                        456789

Store Number 2                         9                                        456789

Store Number 3                         2                                        456789      

[Gysbert_Wassenaar]

Create a straight table with Store Name and SKU as dimensions and sum(inventory) as expression.

[Anonymous]

use

aggr(sum(inventory),[Store Name],SKU)

[Qrishna]

See attached for a demo.

[Qrishna]

Any Luck?