Hi, i have 2 field in which i want to add up in Pivot Table (A and B)
i discover i can achieve using Calculated Field and also by adding to Data Model, then add Measurement. I Use [A]+[B] in my formula. But i keep getting error. HOwever, when i use =sum([A])+sum([B]), it work. But is it the ideal formula?
And for my case, just a Simple sum up of two field. Is there any difference between using Data Model (add measurment) and Calculated Field? Which method is prefered?
Bookmarks