How to remove % column in front of total column in Pivote table

[P_Kale]

Hi,

Count({< EARLY_NON ={'EARLY','NON EARLY'}>} POLICY_NO)/Count(TOTAL <FY_YEAR> {< EARLY_NON ={'EARLY','NON EARLY'}>} POLICY_NO) * 100

through above formula i am able to calculate % row wise against total but the formula is getting applied to total column also and 100 is appearing in front of all the rows. I not want this % column in total. How I can remove this.

EARLY_NON	Totals		EARLY		NON EARLY
FY_YEAR	NOP	%	NOP	%	NOP	%
Totals	28200	100	13759	58.69129	14441	41.30871
FY_2015-2016	12000	100	2982	47.26581	9018	52.73419
FY_2016-2017	3400	100	2809	51.70256	591	48.29744
FY_2017-2018	5000	100	2207	53.85554	2793	46.14446
FY_2018-2019	6000	100	2953	70.67975	3047	29.32025
FY_2019-2020	1800	100	2808	81.9854	-1008	18.0146

Thanks in advance

@marcus_sommer 

@swuehl 

@sunny_talwar 

@Anil_Babu_Samineni 

[Anil_Babu_Samineni]

@P_Kale I meant to say this way,

Sum(Aggr(If(ValueList('EARLY','NON EARLY','Total')='EARLY' and Measure='NOP', count({<EARLY_NON={'EARLY'}>} POLICY_NO),
If(ValueList('EARLY','NON EARLY','Total')='NON EARLY' and Measure='NOP', count({<EARLY_NON={'NON EARLY'}>} POLICY_NO),
If(ValueList('EARLY','NON EARLY','Total')='EARLY' and Measure='NOP%', Num(sum(Aggr({< EARLY_NON ={'EARLY','NON EARLY'},CONSIDER_NOT_CONSIDER = {'CONSIDER'}>} POLICY_NO))/sum(Aggr({< EARLY_NON ={'EARLY','NON EARLY'},CONSIDER_NOT_CONSIDER = {'CONSIDER'}>},<FY_YEAR> POLICY_NO),'##.0%')
)))), FY_YEAR))