HI All,
I need a quick help in presenting data in Pivot table.
| MOCID | StoreCode | Status |
| 1 | 1 | C |
| 2 | 1 | NC |
| 3 | 1 | NA |
| 4 | 1 | C |
| 5 | 1 | C |
| 1 | 2 | C |
| 2 | 2 | NC |
| 3 | 2 | NA |
| 4 | 2 | C |
| 5 | 2 | C |
| 1 | 3 | C |
| 2 | 3 | NC |
| 3 | 4 | NA |
| 4 | 4 | C |
| 5 | 4 | C |
| 1 | 5 | C |
| 2 | 5 | NC |
| 3 | 5 | NA |
| 4 | 5 | C |
| 5 | 6 | C |
With PIVOT table I can present the data as :
| StoreCode | MOCID | 1 | 2 | 3 | 4 | 5 |
|---|
| 1 | | C | NC | NA | C | C |
| 2 | | C | NC | NA | C | C |
| 3 | | C | NC | - | - | - |
| 4 | | - | - | NA | C | C |
| 5 | | C | NC | NA | C | - |
| 6 | | - | - | - | - | C |
My requirement is to present only the history of different MOCIDs for stores appearing in current MOCID. If I assume MOCID 5 is my present MOC - I need to present only data of StoreCode 1, 2, 4 and 6.
Can someone explain how can I get rid of other StoreCode not appearing in current MOCID?
See attached sample data qvw.
Regards,
TK
