# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Not applicable

## Need Groupwise Total

Dear All;

If I am having a data similar to mentioned below in the table

 Sr No Article Number Brand Price Qty Total Price 1 A1 2011 10 5 50 2 A2 2011 10 5 50 3 B3 2009 10 5 50 4 B9 2009 10 5 50 5 C9 2010 10 5 50 6 A9 2010 20 5 100 7 A7 2010 20 5 100 8 A8 2010 20 5 100 9 A9 2011 20 5 100 10 C7 2011 25 5 125 11 C9 2009 25 5 125 12 C3 2011 25 5 125 13 C15 2011 25 5 125 14 C12 2011 30 5 150 15 A15 2011 30 5 150

and then as a result i need the Brandwise Sum of Total Price like..

 Brand Total Price 2009 225 2010 350 2011 875

I am not able to get the Groupwise Total????

Shantanu

1 Solution

Accepted Solutions
MVP

## Need Groupwise Total

Hi Shantanu,

It is very simple take

Dimension = Brand

Expression = Sum( [Total Price] )

it will give result that you want.

Rgds

Anand

3 Replies
Contributor III

## Re: Need Groupwise Total

Shantanu,

Have a look at the attached appliaction.

-Sridhar

MVP

## Need Groupwise Total

Hi Shantanu,

It is very simple take

Dimension = Brand

Expression = Sum( [Total Price] )

it will give result that you want.

Rgds

Anand

MVP

## Re: Need Groupwise Total

Hi,

See the attached sample file.

Rgds

Anand