Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Shantanu,
It is very simple take
Dimension = Brand
Expression = Sum( [Total Price] )
it will give result that you want.
Rgds
Anand
Shantanu,
Have a look at the attached appliaction.
-Sridhar
Hi Shantanu,
It is very simple take
Dimension = Brand
Expression = Sum( [Total Price] )
it will give result that you want.
Rgds
Anand
Hi,
See the attached sample file.
Rgds
Anand