2 Replies Latest reply on Sep 27, 2018 1:35 PM by Jim Dehner

    Calculated Field ignore filter

    ljubomir stajic

      Hi all,

       

      Hope this is a simple question:

       

      I'm trying to create a calculated field that ignores a filter.

       

      In the attached example, when I filter Federal only, I'd like Calculation2 to remain the same ($271,933).

       

      I tried doing this using the Include function, but evidently that didn't do the job.

       

      { INCLUDE [Major Fund Category]: SUM([Calculation1])}

       

      I would appreciate any help.