Radar Chart Dimensions

[#1]

Dear all,

I have a question concerning definition of axes in a radar chart. I've got 5 categories I want to display as axes. Furthermore I've got lots of data (e.g. companies) for which I have specific values for each category.

By now I structured my data the following way to build the radar chart.

Used Dimensions for the Chart are: Category and Entity

Used Expression is: only (value)

Example:

Entity               Category               Value

A                     Dimension 1               1

A                     Dimension 2               3

A                     Dimension 3               5

A                     Dimension 4               2

A                     Dimension 5               3

C                     Dimension 1               2

C                     Dimension 2               5

C                     Dimension 3               5

C                     Dimension 4               3

C                     Dimension 5               4

Is it possible to build a radar chart like the one above, without multiple lines of categories for every entity, with a data structure like the one below?

Entity               Dimension 1          Dimension 2           Dimension 3    ...

A                         1                                 3                              5           ...

B                         ...                               ...                              ....        ...

C                         2                                 5                              5           ...  

Hope someone can solve my problem....