Subtraction between the grand Total and a subtotal

User_I0GH4

J’aimerais faire la soustraction entre le grand total et un sous-total pour obtenir un autre sous total dans un même tableau.

Peut-on faire cela ?

Dans mon exemple: Ce serait Total - Autres organismes publics

I would like to subtract the grand total from a subtotal to obtain another subtotal in the same table.

Can we do this?

In my example: This would Total - Autres organismes publics

User_I0GH4

Est-ce que quelqu’un peut m’aider svp ? Merci!

Gianni Ceresa

Hi,

You are on a track to get the forum building an analysis matching an Excel spreadsheet something gave you.

First of all: no need to write the French version of the question, the community uses English to stay accessible to anyone (and that's why I do reply in English despite speaking French).

Second point: what you are trying to achieve is possible, but it's generally a kind of analysis that require some specific model. For example it's often sourced from something like Essbase that deals with aggregations rules at all levels and sum or subtract based on the needs.

It's like financial reports: they generally sum some things together, then they do subtract others to product the final financial figures.

In the end, all you are looking for it possible, but it's only a matter of "click here and then click there", there are too many variables to judge across 3 different threads.