Hey
Maybe first I should post this to section powerpivot but it's quiet down there.
So I will post a sample file which contains simplified model (different data)I am working with. In sheet pivot without powerpivot I was able to add calculated fields which divide score by credits. I was not able to do it in pivot genereted from powerpivot in other sheet. And these is what I need to do divide two kind of ratings for many campaings. Problem is also that every campaing uses different ratings and I would end up creating 20 calculating columns in powerpivot which is quite big databases and freezes. Is there other reasonable think I can do apart from copying values from pivot to ordinary sheet a then add columns and perform calculations ?
Maybe first I should post this to section powerpivot but it's quiet down there.
So I will post a sample file which contains simplified model (different data)I am working with. In sheet pivot without powerpivot I was able to add calculated fields which divide score by credits. I was not able to do it in pivot genereted from powerpivot in other sheet. And these is what I need to do divide two kind of ratings for many campaings. Problem is also that every campaing uses different ratings and I would end up creating 20 calculating columns in powerpivot which is quite big databases and freezes. Is there other reasonable think I can do apart from copying values from pivot to ordinary sheet a then add columns and perform calculations ?