Hi
I am hoping there is a macro solution to this hence being in the VBA forum, apologies if it's incorrect placement.
I have a large pivot table restricted by page, row, column and value filters which is currently pulling a MIN for each category from hundreds of different options per category. I need to see which NAME is associated with this MIN value, at the moment I am getting a nice table of all the minimum charge out rates, however I can't see who is providing this rate without drilling down into the transactions, and we are talking a LOT of categories/countries/services/time frames.
Is there a way to pull this into a second cell within the pivot, or even to pull the same pivot layout but display the text label i.e. company name?
Unfortunately I need this to function in excel and cannot use access/mysql as end users need to be able to drill down into transaction, also the data set is updateable, so would need to be able to refresh, hence cannot do this manually (aside from time restrictions).
Any help would be much appreciated!
PS. I am properly useless with macros, so please if this is the solution, I'd appreciate instructions on how to use it :)
I am hoping there is a macro solution to this hence being in the VBA forum, apologies if it's incorrect placement.
I have a large pivot table restricted by page, row, column and value filters which is currently pulling a MIN for each category from hundreds of different options per category. I need to see which NAME is associated with this MIN value, at the moment I am getting a nice table of all the minimum charge out rates, however I can't see who is providing this rate without drilling down into the transactions, and we are talking a LOT of categories/countries/services/time frames.
Is there a way to pull this into a second cell within the pivot, or even to pull the same pivot layout but display the text label i.e. company name?
Unfortunately I need this to function in excel and cannot use access/mysql as end users need to be able to drill down into transaction, also the data set is updateable, so would need to be able to refresh, hence cannot do this manually (aside from time restrictions).
Any help would be much appreciated!
PS. I am properly useless with macros, so please if this is the solution, I'd appreciate instructions on how to use it :)