Dynamic column in matrix

Hi, 

I have a matrix with multiple rows, each of them having a set of values (status of employes). I need to show them side-by-side for each row  (see image 1).image 1

I achieve this by creating a sequence in my sql query which I used as column to split the data on the matrix. 

I got some problems with this 'solution', first is that I can't slice by status since they have this fixed column and the visual stay with this open space... (see image 2).

image 2

Another thing I need is, when I drill-up or down, the status should keep showing side-by-side all the values, but they got summarized as first value and replaced other values on the same columnn (see image 3).

image 3

Is this possible to achieve?

(If something was not clear please let me know, I'll try to explain better, sorry for my english :\)

ps: idk how to upload a file for example :(