### Pivot Table output help

Posted:

**Wed May 16, 2018 1:58 am**Hello, I am fairly new in using Power Pivot and Dax so I will try to be very detailed

Please see attached photo for better explanation

I have Data Model with next columns:

Unit Name Premium Losses Ratio (Losses/Premiums)

A $100 $50 50%

A $100 $50 50%

B $100 $25 25%

B $100 $25 25%

and when I create a Pivot table using this data model I get next:

Unit Name SumOfPremium SumOfLosses SumOfRatio

A $200 $100 100%

B $200 $50 50%

The problem is the last column in my pivot table, where I do not need it to return sum of ratios but the ratio (SumOfLosses/SumOfPremiums).

that would look like this:

Unit Name SumOfPremium SumOfLosses SumOfRatio

A $200 $100 50%

B $200 $50 25%

Thanks in advance for your help.

Please see attached photo for better explanation

I have Data Model with next columns:

Unit Name Premium Losses Ratio (Losses/Premiums)

A $100 $50 50%

A $100 $50 50%

B $100 $25 25%

B $100 $25 25%

and when I create a Pivot table using this data model I get next:

Unit Name SumOfPremium SumOfLosses SumOfRatio

A $200 $100 100%

B $200 $50 50%

The problem is the last column in my pivot table, where I do not need it to return sum of ratios but the ratio (SumOfLosses/SumOfPremiums).

that would look like this:

Unit Name SumOfPremium SumOfLosses SumOfRatio

A $200 $100 50%

B $200 $50 25%

Thanks in advance for your help.