1 Reply Latest reply on Nov 20, 2017 2:36 AM by chris monger

    How to use FIXED for two different dimensions?

    Chadi Atie

      Hello Guys,


      I create this calculated field (see below) to fix the Country, and it works really well. But the thing is that I make another dimension FIXED as well in addition to the country. (The other dimension is called "Agency").


      How can I add it to my formula?


      { FIXED [Country]: SUM(IF [Tickets]=0 THEN [Number of Records] END ) }


      Thanks a lot guys,

      I appreciate your help