View My Drafts
Hi Prem,I don't really get what you mean, if you have 8 columns status, that should work the same as 2 columns unless there are other columns which are are really status. It is possible to do it without using unpivot but every status column is equivalent to 1 measure and you cannot have the same as result. You would have as per below table.
I suggest that you show the snapshot of your table and let see what other option we may have.