I have a issue in my pivot table. I have a dimenison called cal and expression is sum(amount). In my cal field i have 3 values A,B,C.
B+C is the value of A. Example: sum(amount) for A is 10, and sum(amount) for B is 5 and c is 5. I have enabled the total for the dimension and the total is showing 10 instead of 20. I am not sure what is the issue. Can someone help me please.