Need Groupwise Total

[#1]

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????

Thanks in Advance!

Shantanu    

[sridhar240784]

Shantanu,

Have a look at the attached appliaction.

-Sridhar

[its_anandrjs · Accepted solution]

Hi Shantanu,

It is very simple take

Dimension = Brand

Expression = Sum( [Total Price] )

it will give result that you want.

Rgds

Anand

[its_anandrjs]

Hi,

See the attached sample file.

Rgds

Anand