Adding total expression to pivot with horizontal dimension

[dafnis14]

Hi,

I have a pivot table with months as horizontal dimension.

I need to add totals expressions with some set analysis, which should appear only at the end (for all months only).

currently they appear for each month.

Attached is the expected report format.

The yellow represents actual value. The grey - forecast values.

Please note that the Total Actual includes  actual month values only.

Would appreciate suggestions how to do it.

Thanks!

[dafnis14]

If i may..

Is there a way to add an expression that would show only as a Total?

Currently, it is added for each month.

Seems that for such a case, the HorizontalDimensionality doesn't work.

Thanks!