1 Reply Latest reply on Jan 16, 2019 11:10 AM by Jim Dehner

    Leave One Value, Keep Calculation

    Martin Overly

      Do I need to use some kind of calculation to leave one value, but still have it calculate? For example, if I want to exclude "Over Age 25" from my visualization, but still show 42% instead of it going to 100% when I exclude Over Age 25, how do I do that?

      Screen Shot 2019-01-16 at 11.45.07 AM.png

        • 1. Re: Leave One Value, Keep Calculation
          Jim Dehner

          Martin that depends on how you calculated the percentages - it could be as simple as filtering out the "Overage age 25" by placing the dimension on the filter shelf

          but I suspect you used a table calculation that would looks something like this since I don't have your workbook you will need to extrapolate from superstore data


          SUM([Sales]) / TOTAL(SUM([Sales]))



          Change it to look like this

          sum([Sales])/sum( { FIXED   :(SUM([Sales]))})

          then you can filter the over 25 out




          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.