Nested aggregation / calculation

[bramvdpoel]

Hi,

I have a calculated value in my chart: ((Sum(A)-Sum(B))/Sum(C)*100))

Now i want to add different colums to a table where with a condition a Field X

SO: {<FieldX=10>} ((Sum(A)-Sum(B))/Sum(C)*100))

I want it to be a fixed column, so regardless of the made selections.

can anyone help?

Thx

[tm_burgers · Accepted solution]

(Sum( {1<FieldX={'10'}>} A)-Sum({1<FieldX={'10'}>}B))/Sum({1<FieldX={'10'}>}C)*100)