Forum Discussion
Pivot Table - Showing Percentage
What I am looking to show as part of this very basic pivot table is the % of Fuel Units against the total for each of the branches. Not sure why I am struggling? I thought pulling the values of the f...
I guess you would like to show per cent of Fuel Units to Total Units, not per cent to total in row. Since you have no columns which separates data on something (divisions, countries, whatever), total in row is equal to value in row (only one column for Fuel Unit). Thus always 100%.
If you load data to data model you may add DAX measure like
=DIVIDE(SUM(Table[Fuel Units]), SUM(Table[Total Units]), 0)to show such per cent.
Or, if without data model, calculated field like
= 'Total Units' / 'Fuel Units'and sum it in aggregation.