Forum Discussion
customisable matrix view
Hello, In my report I would like to present some data in table where I define each box. My data are all in one row and I would like to make 2 visual. Here's a simplified version of what I'd like...
I can't unpivot my data because I have too much calculation to do and and these calculations depend too much on the nature of the data.Unpivot your data.
Then in your matrix visual you can re-purpose the column total to show the average instead.
Hello,
The average is one of the reason why I can't unpivot data, because it's not a simple average, but a weighted average dependent on a parameter.
You can implement that logic in the measure for the column total.
Remember that in a matrix visual each measure is calculated four times.