Please help to check our challenge as below.
Now our dimension was like
And Measure was like
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.
Solved! Go to Solution.
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?
Great! Works now! Thanks very much.
But Could you help to explain why you used the dimension above? Can you help to explain and let us know the reason. Thanks.