The field AA and AB are in the data model, AC not association with the data model as the new CR, so we dont want do the change for current data model, but for the case, once we used the straight table, it works fine, but for pivot table, the value was not correct, once we add data model Dimension in pivot table, then its correct. So Any one can share some experience for the case? Thanks.
You mentioned in your initial post that it works in Straight table, but not in Pivot table.... but in your sample it seems to be not working for either of them. Is that correct or am I missing something here?