• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

pivot with and without powerpivot

tomas

Active Member
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 ?
 

Attachments

  • EMT812.xlsm
    161.7 KB · Views: 7
Back
Top