Table expression ignoring my calculated dimension

[oxiofrt]

Hello, 

I have created a pivot table.

I would like to have in each column (1,2,3,4,5) the total sum of the values of the line.

It's not easy to explain, but I have create an app with comment which shoulg helps a lot.

Thank you for your help

[sunny_talwar · Accepted solution]

Try this

=Aggr(NODISTINCT Sum( NB_DEPARTS_ENGINS * FL_SEUIL), SECTEUR)

[oxiofrt · Accepted solution]

Thank you so much for this fast and efficient solution !

Great 🙂