Hello
I have a pivot table that shows totals by merchant within card types. My data looks something like:
Merchant
Cardtype 444444 55555555
Visa 200 4400
Electron 1000 60
Mastercard 600 900
I need to pick up the values from specific totals e.g. the 1000 from cardtype electron for merchant 444444.
I have spent ages trying to find out how to do this and failed.
If anyone can help with this you'd save my life.
Thanks.
Regards
Chris Bezant
I have a pivot table that shows totals by merchant within card types. My data looks something like:
Merchant
Cardtype 444444 55555555
Visa 200 4400
Electron 1000 60
Mastercard 600 900
I need to pick up the values from specific totals e.g. the 1000 from cardtype electron for merchant 444444.
I have spent ages trying to find out how to do this and failed.
If anyone can help with this you'd save my life.
Thanks.
Regards
Chris Bezant