Hi Friends,
Please find the attachment for the image of tables .
The Link from A to B is a key which is like primary key and A to C also as same. In Table D we are having company,Division,Business,Product codes and their description along with the amount. The same Information in Tables E and F also. But, The amount will be differ according to the description in three tables. Table A is linked to D, E, F by creating composite key as Company code,Product code,Business Code,Division Code.
I Need to show the calculated amounts in a single pivot chart with the description and year. I'm getting the repeated amounts when showing it. Kindly help me out how can we change the link between tables.
Regards
Krishna
