Show the sum of a calculated column in a text field, based on page filters

[Janson Ribeiro]

I made a calculated column that takes all the values of a delayed status.

Then I added these values in the text field, but it is adding all the values instead of adding only the values that are being filteredThats my collum code:

If([PAIN_NM_STATUS_COMP]="DELAYED",[PAIN_MD_VALUE_STATUS])

How to add these values taking the page filters in a text field

[Fabian Duerr]

A calculated column will always use all rows from a data table for the calculations. Only in visualizations you can select what values should be used for the calculation. Also the input to any data function can be limited to filtered values.

I'm not 100% clear of what you want to achieve. But maybe a cross table could be helpful.

You can also add a small dxp file to better show what you want to do.

[Kevin Flynn]

You can create a new filter scheme that isn't the same as the page you are on. You can then update the calculated value in the Test Area to use the other Filter Schema.