Filter so it doesn't show up in report




  • Official comment
    David Sallusti

    Hi Stacy,

    I think this is what you mean.

    IF you have 10 Service Codes, you only want to display the values of certain ServiceCodes without displaying the rest.

    For example:

    As you can see, the list shows all service codes and Visit distinct count per service code:

    However, you want to create a COLUMN to show a SUM of PT and WNDCARE above (within Calculation 1) you see the two values summed up.

    I used a formula to SUM the two first and the another formula to identify which ones should be included in the visual tool or not.

    First formula SUMS the values based on the IF formula and second Calculation will display YES or NO based on what we defined (PT and WNDCARE) in this case

    You will be able to then Filter on "Hide No's"

    And your end result would be this:

    Comment actions Permalink
  • Avatar
    David Sallusti

    Hello Stacy! Do you have a sample screenshot output of the desire results so I can review and get back to you?

    Comment actions Permalink
  • Avatar
    Stacy Marzik

    Hello - don't think I was explaining correctly, because I don't think it should be this complicated? All of our reports use filters that do not actually appear in the report. For example here is an employee report where there is the Employee status filter that does not show in the report but the report reflects it. 

    I might be missing something but the filters are usually the first thing I do in my reporting now, and THEN I input the fields I want to make sure it is correct. 

    How do I accomplish this in DE 2.0?

    Comment actions Permalink

Please sign in to leave a comment.