3 Replies Latest reply on Feb 6, 2013 6:22 AM by Joshua Milligan

    Calculation of a new characteristic of a dimension - measure variable to my selected existing characteristics

    Alexander Herzog

      Hello Everybody

       

      I have a question to you and hope, that anybody could help me:

       

      Is it possible to calculate a new characteristic of a dimension, which is variable to my selected existing characteristics? Maybe this sounds a little bit confusing, but let me explain it with an example :

      I have a dimension called « person » and a measure called « Ppints ».

       

      Here are the persons with their points:

      person a has 30 points

      person b has 20 points

      person c has 10 points

      person d has 5 Points

      I know that the total of points is « 100 », but the system doesn’t know this yet.

       

      First of all I have to calculate a new characteristic of the dimension « person » called « other persons », so that I am able to say, what is the rest of the total.

      Other Persons = Total - person A - person B – person C – person D

      How can I do this ?

       

      Then I have to say tableau, that the total sum of points is 100 – is this possible ?

       

      After solving these problems – here is the next question:

      Is it possible to calculate the „other persons“ in addiction to my ‘in Tableau’ selected persons?

      dimension « person » – in rows

      measure « points » – on columns

      I have the dimension on my filter – when I select « person a and b », the « other persons » would be 50.

      When I select only « person c », the « other persons » would be 90.

      a.s.o.

      Is this possible to program such a calculation ?

       

      Thanks a lot,

      Alexander