Total in Pivot Table

[soha1902]

Hi All,

I am having some product which associated to CAT 1 or 2 or both. Now I want to show two charts, one for PRD1 which associated to CAT1 and another one which associated to CAT2. When I am doing this then expression showing total sum but I want individual sum like left side table in below image. Please suggest.

[Anonymous · Accepted solution]

Your 2 tables are not joined, so summing Sal against against PRD1 or PRD2 gives you the misleading Cartesian join.