Hi guys,

Just wanted to ask how can I get the TOTAL part in this report?

I already got the TOTAL in the ROW part, the one with 100%, 28%, 33%, 38% and 100%, 26%, 33%, 41%.

However, I can't figure out how to get the TOTAL in the COLUMN section. I already tried several ways like using SUMRT, constant selection, exception aggregation, and other ways I could think but I still can't get it. I can only manage to get the PERCENTAGE in COLUMN based on the total value of all plants and not per PLANT.

This is my result for now. Columns in RED have incorrect values.

My idea for now is to get the SUM of each plant per type so I will have the denominator for the computation in the TOTAL column part but I wasn't able to get it.

Any help?

**NOTE:**

The KEYFIGURE being used is NON-CUMULATIVE so constant selection is not working. Below is the error message.

Thank you.

Loed

## Add comment