How to do aggregation in Chart - table

[soloeeeoff]

1. I want to represent data in the (Data_1 --> Sheet 1 ) as (Data_1 --> Sheet2).
2. 

[Anil_Babu_Samineni]

Is this you are expecting?

I've update new one, My muistake

[sunny_talwar]

Another option would be to create three new expressions like this:

=Sum(Mark1)/Sum(TOTAL Mark1)

=Sum(Mark2)/Sum(TOTAL Mark2)

=Sum(Mark3)/Sum(TOTAL Mark3)

[soloeeeoff]

Dear Anil,

Can you please tell me what is the difference between

1. Sum(Mark1)

2. Sum( All Mark1)

3. Sum(Total Mark1)

4. Sum(Distinct Mark1)

5. Sum(${Mark1} Mark1)

[Anil_Babu_Samineni]

I recommend you start your self by hand then you will get more clarification. please find attachment then observe, Which is make sense...

With %

Without %