Would it be possible for future versions to have a column in the holdings tab which would show what the percentage is of each stock in the account/portfolio accounts for?

Note: This percentage is calculated just against Symbol table. That is - if you will select slicer Account value, "Portfolio %" will show percentage in that selection.

I am assuming that you have "Full" PowerPivot support - that is you have PowerPivot menu in Excel. If you do not, then you cannot add this measure yourself. In Excel 2016: 1. Go to Holdings tab. Select any cell inside holding pivot table. 2. Choose PowerPivot menu, select arrow down below "Measures" button and choose "New Measure". 3. TableName : choose Report. 4. Measure name: enter Portfolio % 5. Formula - enter formula above 6. For formatting choose "Number" and then "Percentage" 7. Click OK.

Sorry - I think one more step is missing in my description. select any cell in that pivot, then on the right you should see list of fields. If you do not see list of fields, then right mouse click and choose "Show Field List". From that field list expand table "Report" and check "Portfolio %" new measure.

And just to add - if you select just one "Account" then this value will be for one account. If you want to show portfolio % independent of account selection, you should change formula to:

## Comments

Will be done - measure name "Portfolio %". You can add this measure yourself for now using following formula: Note: This percentage is calculated just against Symbol table. That is - if you will select slicer Account value, "Portfolio %" will show percentage in that selection.

Could you tell me where exactly I would add the formula you suggested.

Thank you.

How to add new formula depends on Excel version (or different steps for PowerBI). What Excel version are you using?

In Excel 2016:

1. Go to Holdings tab. Select any cell inside holding pivot table.

2. Choose PowerPivot menu, select arrow down below "Measures" button and choose "New Measure".

3. TableName : choose Report.

4. Measure name: enter Portfolio %

5. Formula - enter formula above

6. For formatting choose "Number" and then "Percentage"

7. Click OK.

I followed your instructions but it doesn't want to seem to populate to the report. I've included screen shots...

Any suggestions?

Sorry I do not see P2.png screenshot - I do not see if value is 0 or if some value is calculated?

Sorry - I think one more step is missing in my description.

select any cell in that pivot, then on the right you should see list of fields. If you do not see list of fields, then right mouse click and choose "Show Field List". From that field list expand table "Report" and check "Portfolio %" new measure.

That extra step did the trick! I preferred it being for the account selection - so the first formula you provided.

Thanks so much!