Hi
If I have a simple database in Excel consisting of COST CENTRE, ACCOUNTANT, VALUE for each of 12 months and ACCOUNT NUMBER and I have pulled this into a pivot table where the column area is the 12 MONTHs, the Row Area is the ACCOUNT NUMBER and in the Page Area I have the ACCOUNTANT and COST CENTRE number so that I can filter my data according to accountant or cost centre.
When I apply the accountant filter (in page area) , excel does not automatically limit the cost centre filter to only those cost centres applicable to the accountant chosen. Is there some way that I can link the two filters to that I don't see all cost centres when I have filtered for a single accountant.
Regards
If I have a simple database in Excel consisting of COST CENTRE, ACCOUNTANT, VALUE for each of 12 months and ACCOUNT NUMBER and I have pulled this into a pivot table where the column area is the 12 MONTHs, the Row Area is the ACCOUNT NUMBER and in the Page Area I have the ACCOUNTANT and COST CENTRE number so that I can filter my data according to accountant or cost centre.
When I apply the accountant filter (in page area) , excel does not automatically limit the cost centre filter to only those cost centres applicable to the accountant chosen. Is there some way that I can link the two filters to that I don't see all cost centres when I have filtered for a single accountant.
Regards