Power Pivot - Dividing two columns

[chriswein]

Hey, I have two columns (dollar discount, active customers) in a connection in power pivot in excel. I want to divide them by each other. In power pivot the calculation looks like it works correctly for every row. When creating a pivot table from that in excel it doesn't aggregate the calculation properly. I tried either the iferror(a/b,0) and also =divide(a,b) But to no avail. What am I missing?

[#2]

@chriswein 

What exactly is wrong, could you please provide bit more details? And what do you aggregate - calculated column or measure?

[#3]

@Sergei Baklan I think I just found a solution. I had to create it outside of powerpivot, just in the regular excel UI. powerpivot tab and then create a new measure. That way the aggregation worked correctly!