Hi,
I need some help on pivot tables. I have 2 different pivot tables in 2 different worksheets with similar data reference. These 2 both have "Week No." and "Monthly" report filters. If I choose specific value for "Week No.", then the "Monthly" filter should have "(All)" value and vice-versa...
Hi,
Below is the format of my excel file. Basically, I have skills in the first column and the suceeding columns are rating (1 lowest and 5 highest) of each person on a particular skill. I have several skills in line but i only listed some for the sake of this sample. What I want to do is to...