total in dimension and mesure on straight table

[simoevry]

Hi guys,

I've problem with total If someone here could helpme .

this is my expression :

((MIN(Valeur)-Above(Max(Valeur))))/100

thank you !!

[sunny_talwar]

What exactly is the issue? Can you elaborate with an example from the image you have posted?

[simoevry]

Hi Sunny

Normally I must got this result in total columns for example : 115,04+99,20=214,20

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr(((Min(Valeur)-Above(Max(Valeur))))/100, [Descri], [MyDate_2], [hour1]))

[simoevry]

It's works for me thank you so much Sunny 😊

[simoevry]

I still have this issue when I wanna Deselect the selection, I 've seen the total not correct with negative value bellow

attachement :

[sunny_talwar]

What does the total need to show? Sum of rows?

[simoevry]

I need both of them

[sunny_talwar]

Both of them? What do you mean?

[simoevry]

I need to show total row and columns It's work but when I deselect the selection [Hour1], I got negatives values.

You can find the attachement bellow.