i have posted up this question on this thread . https://community.qlik.com/message/1131226?et=watches.email.thread#1131226
however, my problem comes back. Client want to simplify it. in a way that...
1) Wihtout selected any filters/dimensions, the pivot table display all the data with white backgound color(as usual).
2) User select selections from filters(select 1 or more)
3) the filtered data inthe pivot table will be display with background colors, other columns will remain in white background color.