Forum Discussion
Solved
Matrix visual help
Hi, I am building the matrix visual input Group Status 1 B 2 A 3 C matrix that i got to is (each 1 is a count) Group A B C 1 1 2 1 3 ...
Without context I would say that you just need to create a measure like Measure = COUNTROWS(Status)*80 and put in the "Values" of the Matrix.
thank you . works great.
one more question if you dont mind.
step 2 that i need to do is to find the difference between columns B and C (result of transposing).
to provide more context i will provide a better example
Group A B C still in progress 1 3 3 1 =3-1 2 1 3 3 3 1 Group A B C Still in progress 1 240 240 80 =240-80 2 80 0 0 3 240 240 80