Google Data Studio - dynamic tables

[vecchiasignora]

Hello every body, 

I am trying to display a matrix in a Google Data Studio using a dynamic table with a row dimension and a column dimension but my problem is that the metric seem to be only possible as an aggregation over my data but in my case the values I want to show in the cells is a fix value that I have already calculated, so I dont need to apply any aggregation function for my metric

is it possible with a dynamic table ? or have I to use another type of table ?

Now as a metric it is applying a count function over my field 'cversion', muy instead I a would like to display the value of the field 'cversion' itself

for every row and column dimension, the value of the metric (cversion) is unique ... the ratio is 1:1:1, this is why the aggregate count function displays always 1 in the table

this is MySQL data source:

Any clue ? 

Thanks very much in advance ... this is driving me crazy

Regards!!!

[kolban]

I am not familiar with the concept of Dynamic Tables in Looker Studio.  I did a Google Search on "data studio dynamic table" and came up blank.  Can you elaborate on what you mean by a "dynamic table"?

[VishalBulbule]

@vecchiasignora 

Whenever you add datasourse and pull data in sheet by default it will show aggregation at the first, you can remove aggregation just by removing clicking cross ❌ symbol in right pain. you can refer this video, may be first 2 min in datastudio(now looker studio)

https://youtu.be/WcfpvzmB0as