topic Row wise % is not getting calculated in pivote table in App Development

Row wise % is not getting calculated in pivote table

P_Kale — Wed, 31 Jan 2024 05:06:57 GMT

Hi,

I have created a pivote table having 2 dimensions where i want row wise % of total. I have written below formula but it is not giving any out-put but giving blank. Also i want % only for Early & Non Early and not for total column.

Count(POLICY_NO) / count( total FY_YEAR POLICY_NO)

Pl help to resolve the issue.

Thanks in advance.

@marcus_sommer

@Anil_Babu_Samineni

@sunny_talwar

Re: Row wise % is not getting calculated in pivote table

Anil_Babu_Samineni — Wed, 31 Jan 2024 05:11:01 GMT

@P_Kale Not sure the Idea, by seeing syntax either one below. Did you tried this?

Count(POLICY_NO) / count( total POLICY_NO)

Count(POLICY_NO) / count( total <FY_YEAR> POLICY_NO)

Re: Row wise % is not getting calculated in pivote table

P_Kale — Wed, 31 Jan 2024 05:35:34 GMT

Thanks for your help @Anil_Babu_Samineni

I have attached 1 excel below where what i am getting through formula which you have given

Count(POLICY_NO) / count( total POLICY_NO) is given also what i have needed that also given in Yellow colour.

Count(POLICY_NO) / count( total <FY_YEAR> POLICY_NO) this formula not giving any values in % column.

Re: Row wise % is not getting calculated in pivote table

Anil_Babu_Samineni — Wed, 31 Jan 2024 05:56:50 GMT

@P_Kale Can you maybe try this way.

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

Note, sometimes you need *100 or /100 based on the format you get the outcome.

Re: Row wise % is not getting calculated in pivote table

P_Kale — Wed, 31 Jan 2024 06:57:09 GMT

Thanks @Anil_Babu_Samineni

The formula is working only on Total column but not on entire summary.

EARLY_NON	Totals		EARLY		NON EARLY
FY_YEAR	NOP	%	NOP	%	NOP	%
Totals	23443	1	13759	0.586913	9684	0.413087
FY_2015-2016	6309	0.269120846	2982	0.127202	3327	0.141919
FY_2016-2017	5433	0.231753615	2809	0.119823	2624	0.111931
FY_2017-2018	4098	0.174806979	2207	0.094143	1891	0.080664
FY_2018-2019	4178	0.178219511	2953	0.125965	1225	0.052254
FY_2019-2020	3425	0.146099049	2808	0.11978	617	0.026319

Re: Row wise % is not getting calculated in pivote table

P_Kale — Wed, 31 Jan 2024 08:34:51 GMT

Hi @Anil_Babu_Samineni

I able to resolve the issue with below given formula.

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

now need only help to remove % column which is appearing against total column.

Re: Row wise % is not getting calculated in pivote table

Anil_Babu_Samineni — Wed, 31 Jan 2024 16:30:07 GMT

@P_Kale Does it mean, you want to hide % column for both below and need only for Totals?

EARLY

NON EARLY