3 Replies Latest reply: Sep 20, 2011 11:49 AM by Anand Chouhan

# 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

• ###### Re: Need Groupwise Total

Shantanu,

Have a look at the attached appliaction.

-Sridhar

• ###### 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

• ###### Re: Need Groupwise Total

Hi,

See the attached sample file.

Rgds

Anand