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.