I am trying to build a report of the following format:

```
Some Column A | Some Column B | Some Column C | Percentage Allocation
-------------------------------------------------------------
Value N | Value B | 100 | 10%
Value C | Value S | 200 | 20%
Value D | Value Y | 300 | 30%
Value A | Value X | 400 | 40%
-------------------------------------------------------------
| 1000 |
```

The `Percentage_Allocation`

column should be calculated like this: 100/1000 * 100

I have created two variables:

`GRAND_TOTAL`

defined as the sum of the values in `Column C`

and `PERCENT_ALLOCATION`

defined as `Field value of Column C divided by GRAND_TOTAL`

The output I get is:

```
Some Column A | Some Column B | Some Column C | Percentage Allocation
-------------------------------------------------------------
Value N | Value B | 100 | 100%
Value C | Value S | 200 | 66%
Value D | Value Y | 300 | 50%
Value A | Value X | 400 | 40%
-------------------------------------------------------------
| 1000 |
```

I understand that this is happening because the value of `PERCENT_ALLOCATION`

is being calculated as and when a new row is created on the report. But I want it to be calculated only when all the details have been loaded. Maybe this is not possible? I don't know, is there something I can do to achieve my target output?

UPDATE:

So I've figured out that there's a property called `Evaluation Time`

which can help me decide when the column `PERCENT_ALLOCATION`

should be calculated. I have set it to `Report`

so that the value of `GRAND_TOTAL`

takes the sum of all the values in `Column C`

. But now I find that `PERCENT_ALLOCATION`

is being calculated using the **last value** in `Column C`

only. So my report looks like this:

```
Some Column A | Some Column B | Some Column C | Percentage Allocation
-------------------------------------------------------------
Value N | Value B | 100 | 40%
Value C | Value S | 200 | 40%
Value D | Value Y | 300 | 40%
Value A | Value X | 400 | 40%
-------------------------------------------------------------
| 1000 |
```

Thanks.