Forum Discussion

LesleyF's avatar
LesleyF
Copper Contributor
Jun 25, 2021

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 fuel recharge units down again and showing the value as % of row total would work but it doesnt 😞

 

 

 

BI & Data Analysis
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 25, 2021

    LesleyF 

    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.

Resources