Skip to Content
0
Former Member
Dec 10, 2011 at 02:11 PM

Query

14 Views

Hi

Suppose party has following Invoice Details .

Party Name : abc

Item Quantity Value

A 1 1000

A 3 3000

B 2 1000

I want a query using rollup which should display information like this

Party name Item Quantity Value

abc A 4 4000

4000

B 2 1000

Thanx