Forum Discussion
New matrix issue
I'm using new matrix since it allows to click and filter the page elemnts (not possible in other matrixs). To have a flat format, I put all my fileds in value group insted of row goup, but thi...
In your second image, if you put the PM field in Value box, this field will be aggregated so that it will show the incorrect data. You should put it in Row Group. However, it will be populated into next level within same column. Since you need a flat format, I suggest you still use table visual and use a sclier to filter data. I suggest you post a feature request on idea.
Regards,
I take your point about putting the filed in the VALUE box and the aggregation bahaviour.
However, for each value in the ROW group there is only one corresponding value for fileds in VALUE group and the aggregation should return the correct value.
It could be a mistake in data selection of the New Matrix
Regards