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 That is nature to align for all column per dimension, To mitigate this I guess the option using Pick(Match()) with some Island table combination .

[P_Kale]

Thanks @Anil_Babu_Samineni 

Can you pl help how to do this. I have never used this so far.

Thanks in advance.

[Anil_Babu_Samineni]

@P_Kale I don't have sample QVF, if you can share I can help with dummy data.

[P_Kale]

Thanks @Anil_Babu_Samineni for taking time and providing help.

Below attached is the sample data as requested.

[P_Kale]

@Anil_Babu_Samineni  is there any way to hide 100% column from pivote table.

Thanks in advance

[Anil_Babu_Samineni]

@P_Kale I will have a look later and get back to you! I assume you will be having more than 2 for this dimension "EARLY_NON" values?

[P_Kale]

Thanks @Anil_Babu_Samineni 

No problem. Yes I am having for Early 1 value and for Non-Early 1 value.

Thanks in advance.

[qv_testing]

Try this

LOAD [Policy Number],
Claim_Type,
FY_YEAR
FROM
[SAMPLE_DATA.xlsx]
(ooxml, embedded labels, table is Sheet1);

LOAD FY_YEAR,
Count([Policy Number]) as Total
FROM
[SAMPLE_DATA.xlsx]
(ooxml, embedded labels, table is Sheet1)
Group by FY_YEAR;

[Anil_Babu_Samineni]

 @P_Kale Perhaps this? QVF attached for ref.