Janson Ribeiro Posted June 22, 2022 Share Posted June 22, 2022 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 Link to comment Share on other sites More sharing options...
Fabian Duerr Posted June 23, 2022 Share Posted June 23, 2022 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. Link to comment Share on other sites More sharing options...
Kevin Flynn Posted June 23, 2022 Share Posted June 23, 2022 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now