Power pivot

%3CLINGO-SUB%20id%3D%22lingo-sub-1669590%22%20slang%3D%22en-US%22%3EPower%20pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1669590%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22question-details--question-header-container--8scxJ%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22font-text-xs%22%3E%3CSPAN%3EHello!!!%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22font-text-xs%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22font-text-xs%22%3E%3CSPAN%3EI%20have%20a%20problem%20in%20my%20excel%20power%20pivot.%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22question-details--body--Kub7K%22%3E%3CP%3EHow%20can%20i%20insert%20a%20calculate%20formula%20from%20the%20same%20column%3F%3C%2FP%3E%3CP%3EI%C2%B4ve%20a%20column%20wich%20was%20insert%20by%20me%20from%20other%20column.%3C%2FP%3E%3CP%3EThe%20first%20column%20has%20diferent%20types%20of%20margin%20(like%20MRG1%2C%20MRG2%2C%20MRG3)%20and%20different%20types%20of%20sales%20(like%20VB1%2C%20VB2%2C%20VB3).%20I%20added%20a%20column%20with%20just%20Margin%20and%20sales.%20And%20know%20when%20i%20make%20the%20power%20pivot%20i%20see%20in%20a%20column%20the%20sales%20and%20in%20the%20other%20the%20margin.%20How%20can%20i%20make%20other%20column%20with%20de%20%25%20Margin%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
 
Hello!!!
 
I have a problem in my excel power pivot.

How can i insert a calculate formula from the same column?

I´ve a column wich was insert by me from other column.

The first column has diferent types of margin (like MRG1, MRG2, MRG3) and different types of sales (like VB1, VB2, VB3). I added a column with just Margin and sales. And know when i make the power pivot i see in a column the sales and in the other the margin. How can i make other column with de % Margin??

 

Thanks!!

0 Replies