8 Replies Latest reply: Dec 6, 2011 4:01 AM by Julien ROUBERTOU RSS

    Table Chart : List all values related to a dimension

      Hi all !

       

      Here is my problem : I have projects linked to a department.

       

      Data look like this :

       

      ProjectDepartment

      PRJ_1

      US

      PRJ_2US
      PRJ_3US
      PRJ_4UK
      PRJ_5UK
      PRJ_6FR
      PRJ_7FR
      PRJ_8FR
      PRJ_9JPN

       

       

      I would like to buid a table, listing my projects by department. It should look as below :

       

      USUK
      FRJPN
      PRJ_1PRJ_4PRJ_6PRJ_9
      PRJ_2PRJ_5PRJ_7
      PRJ_3
      PRJ_8

       

      => Table box displays distinct line for each project but is not customisable (pivoting line to column is not possible. Merge header cells is not possible too)

      => Straight/Pivot table works with dimension and expression. US, UK and FR departments have several projects and QV can't display them all (it shows "-" as null because QV can't "choose" only one value). It seems like I have to aggregate.

       

      The closest solution I have is to concatenate projects for each department :

      =Concat (distinct [Project Code], Chr(10))

       

      I get this result but it's not what I want. User must be able to select (by click) project, one by one and not a list :

       

      USUKFRJPN

      PRJ_1

      PRJ_2

      PRJ_3

      PRJ_4

      PRJ_5

      PRJ_6

      PRJ_7

      PRJ_8

      PRJ_9

       

      Any ideas ?

       

      Thanks in advance

       

      Regards,

      Julien