7 Replies Latest reply on Apr 6, 2016 12:35 AM by Andrew Watson

    Difference among members of a dimension.

    Sina Zarafshan

      Hello Community!

       

      This is my first question ever! and I hope you do not mind if it's too simple to answer.

       

      Say, I have a dataset, like the super store. I have a dimension that has 5 members, like sub-category in super store that has several. Now, I want to show the difference between sales of members compare to sales of the member 3. How can I create a Calculated Field that basically do this: if [sales of member 3] - [sales of member x] > 0 Then "High" Else "Low". How to denote "of" in Calculated Fields?

       

      Any help is greatly appreciated.

       

      Thanks!