Add new columns separately yo Matrix Table

Question

Hi,&nbsp;I am trying to add new columns into the MATRIX table below;&nbsp;This is the table i do have currently;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This is all working fine, now i want to add several new columns to this Matrix. Please see below what i am looking for; (For Example 2 columns below but there 7-10 columns i will add)&nbsp;As you can see above "Number of Settlement" and "Number of Warning" are totally speparate Columns which has nothing to do with ROW and COLUMN headers (Left Side).&nbsp;I am looking for count of certain cases based on different scenario.&nbsp;Any suggestion would be appreciated&nbsp;I tried with MATRIX and ACETRYS MATRIX LIGHT tables but its not working because whenever I add new columns it usually come inside column header which i dont want. New column must be seperate.&nbsp;Thanks

parry2k · Answer

damit23183&nbsp;there is a workaround for this, see attached and you will get an idea, look at the matrix with the blue background, you need to apply the similar logic.
&nbsp;
I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
&nbsp;
&nbsp;

damit23183 · Answer

Hi,&nbsp;Yes I went through it which i already have that is total of each row but, I would like to add new columns which has nothing to do with current and lastyear values. If you take your example then ALL Total / Grand Total column is sum of rows and columns value.&nbsp;If you take your example then I would like to add two new columns into the existing Matrix;&nbsp;&nbsp;1) No of products where date is not Null = NOPWON2) No of Products where date is null = NOPWN&nbsp;This is just an example;&nbsp;Your example should look like below; this is an example from EXCEL but this is what i am looking for.&nbsp;&nbsp;&nbsp;Thanks

parry2k · Answer

damit23183&nbsp;idea is in the solution I pasted, you have to tweak it as per your needs, you can control whatever you want.

damit23183 · Answer

Hi,&nbsp;Thanks for quick turn around.&nbsp;My apologies, didn't look at Measure that you have created with variable.&nbsp;&nbsp;Thought to be direct solution but i will look into that MEASURE and see how it work.&nbsp;&nbsp;Thanks a lot for your suggestion.&nbsp;Thanks

parry2k · Answer

damit23183&nbsp; as I mentioned, it is not out of the box, you have to create workaround as shown in shared in pbix. good luck.
&nbsp;
I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Forum Discussion

Add new columns separately yo Matrix Table

7 Replies

Related content

Split a column into two separate columns

Matrix Column Widths

Matrix column based on other matrix columns

Matrix column not grouped

separate values into columns