2 Replies Latest reply on Oct 25, 2017 5:52 AM by Branden Kornell

    Fix a Dimension in a formula

    Belen Vera

      Good morning, please, could someone help me on this.

       

      I have a percentage formula

       

       

      SUM([Ventas])/SUM({FIXED
        : SUM([Ventas])})

       

       

      And Segments: F1,F2,F3

       

      F1: 15%

      F2: 25%

      F3: 60%

       

      What i want is if i fillter by segment not to have 100% . I mean, if i filter just by F1 have the 15% not the 100%.

       

      Thanks