Values change when making selection on a Pivot Table

[#1]

Hi All Experts,

I have a table that has values in, but when selecting on an Item, the values change

any idea to solve that matter?

Sample Table:

BEFORE Selection:

Name	Answer
Office	50
Employee	10

AFTER Selection:

Name	Answer
Office	3
Employee	16

Thanks.

[PrashantSangle]

Hi,

Is there any relation between them??

If you dont want to change the value after selection of item then your pivot table expression nullify that field

like

Sum({<item=>}Answer)

Regards