0 Replies Latest reply: May 22, 2013 9:59 AM by Davide Ducco RSS

    Other visualization on pivot table

    Davide Ducco

      Hi,

      I have the need to visualize the best value of a field on a specific dimension and also I need to visualize 'all other values' that are not included in the previous list.

      I try to explain through an example.

       

      I have the following data:

      F1 F2 F3 F4
      A pippo 2 1
      A pluto 4 2
      A pap 6 3
      B cip 2 4
      B paperone 4 6
      B pippo 7 4
      B pluto 11 5
      C pippo 1 8
      C minni 3 6
      C pluto 4 7
      C
      5 2
      C ciop 5 5

       

      I need to have the best value of F2 according to the value of F4, like below:

       

      F1 FirstSortedValue({$<F2-={""}>}distinct F2,F4)
      A pippo
      B pippo
      C ciop

      I need to visualize a fourth value for F1 ('Other') that contain all values of F2 except for the values already listed.

      The result should be the following:

      F1FirstSortedValue({$<F2-={""}>}distinct F2,F4)
      Apippo
      Bpippo
      Cciop
      Otherpluto
      pap
      cip
      paperone
      minni

      Any suggestion?

      Thanks very much in advance.

      Davide