Add New Fields in a PivotTable using Calculated Fields

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

Nice, thanks! What about if your pivot table has values from a lot of formulas and now these names are not in the calculated field list then how to create a calculated field? Like in your case your column names are Sum of Amount, Sum of Tax, and so on. These names are not in the Calculated Field. Thanks

shoppersdream
Автор

Is there no work-around for this "Calculated Field" greyed out?

I'm using a Power Platform - Power BI connection to retrieve the data I need. Everything in the Pivot table I created works bar the Last Field I added to the Values Field.

I added a % of Total Profit field which is working correctly in the grand total column but its also doing it Column by Column which I dont want.

danieljoubert
Автор

What to do if I want only 'net amount' in the pivot table instead of 'sum of net amount'?
Please reply....got stuck with this issue

snehaagrawal
Автор

Hello, i need yo used Average instead sum, but it does not work, for instance, we are trying to calculate the sum of one column divide by the average from another column, do you have any recommendation. awesome video BTW. thanks.

eliasless
Автор

Hi, somehow the the calculated field is greyd out in my excel :( how come? and how to fix that? thnx

ribhisaleh