Forum Discussion
Matrix undefined
Hi Team,
I used matrix visual where i amusing 3 fileds called UNITS,RATIO PERCENTAGE,ERROR DIFF automatically taking Sum. how to avoid auto summarization in Matrix and I want to show zero in blank rows .please find the snippet for reference.
Thanks in advance
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description,I think replace blank value to zreo in PQ first.You can disable total in matrix format.
Like this:
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous ,
The auto summarization is defined at the column level you need to select the column you need and set the summarization to Don't summarize, this however will be applied to all visualizations.
Just for a particular visualization you need to go column by column and set the summarization to Don't summarize on the options of each column:
Regarding the second part of your question to avoid blanks you need to have a measure to have that 0 inforced.
For that you need to have add a +0 or a IF statement. Don't know how your data is set but you can do a SUM, AVERAGE, MAX or MIN to return the values and then add a +0.
Hi Anonymous ,
You need to go to the matrix option and for each column that you place on the matrix and select the option don't summarize:
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description,I think replace blank value to zreo in PQ first.You can disable total in matrix format.
Like this:
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
