percantage of Subtotals according to Grand total...

[cuneyt]

How can I take percantage of Subtotals according to Grand total...

Example: That's what I want

Group Footer1: Sum of Ado.Duration = XXX 30 30%
Sum of Ado.Duration = YYY 50 50%
Sum of Ado.Duration = ZZZ 10 10%

Group Footer2: Sum of Ado.Duration = Total 100

Thanx
Cuneyt

 

[cuneyt]

ooops ok, that was a stupid easy question,

but anyways if someone needs,
here is the answer:
go and create a new formula, write this:

Sum({ado.yourfield}, {ado.yourfiled}) % Sum({ado.yourfiled})

Put it next to your group where your subtotals are....

 

[kskid]

I would copy and paste the subtotal field and then right click on the new subtoal field and click on change summary, then click on show as percentage of grand total.

 

[cuneyt]

yeap, that's a better and easier solution, whatif I'd like to see percantages of the values that are in the same group?

We can call that percantage change...

Example:
Group Footer1: Sum of Ado.Duration = day1 85
Sum of Ado.Duration = day2 68 20 %
Sum of Ado.Duration = day3 50 26.4%
Sum of Ado.Duration = day4 75 -50 %

Formulas are ((day1 - day2) * 100) / day1
(( 85 - 68 ) * 100) / 85 = 20
or
Formulas are ((day2 - day3) * 100) / day1
Formulas are ((day3 - day4) * 100) / day1
goes like that

Thanx
Cuneyt