topic Pivot showing Percentage of row parent total without changing with filter in Row or Column in App Development

Pivot showing Percentage of row parent total without changing with filter in Row or Column

RC_121985 — Thu, 10 Feb 2022 17:21:55 GMT

Hi Experts,

I am facing issue with change in the % when the filter with values in Column.

Below is the sample and out put that i have now.

	Totals	Header			Totals	Items
UID		Match	Mismatch	Missing		Match	Mismatch
000000337102	100.00%	57.14%	14.29%	28.57%	100.00%	83.33%	16.67%
000000337107	100.00%	85.71%	0.00%	14.29%	100.00%	83.33%	16.67%
Grand Total	100.00%	71.43%	7.14%	21.43%	100.00%	83.33%	16.67%

Everything working fine. If i select any value from UID it is showing the same value, but If I select any values from Header/Items (Match/Mismatch/Missing) i see % gets changed. So I should see same value as above no change in the % if there is ant filter.

I have set expression as below;

Count({$< STEP = {'VAL'}, Field 2-= {'Amount helper'}, Result -={'NA'}>}[Registration ID]) /
Count({$< STEP= {'VAL'}, Field 2 -= {'Amount helper'},Result -={'NA'}>} Total<UID, Field_Type > [Registration ID])

Basically i am looking for a Pivot where Filter should be possible but it should not change the values or % when it is filtered.

Attached Sample data

Re: Pivot showing Percentage of row parent total without changing with filter in Row or Column

albertovarela — Fri, 11 Feb 2022 05:38:52 GMT

What if you disregard selections on those 2 fields?

Count({$< STEP = {'VAL'}, Field 2-= {'Amount helper'}, Result -={'NA'},Header=,Items=>}[Registration ID]) /
Count({$< STEP= {'VAL'}, Field 2 -= {'Amount helper'},Result -={'NA'},Header=,Items=>} Total<UID, Field_Type > [Registration ID])

Re: Pivot showing Percentage of row parent total without changing with filter in Row or Column

RC_121985 — Fri, 11 Feb 2022 05:59:11 GMT

Hi Alberto,

Thanks for your reply. Expression you provided is not giving me the desired output. 2 Fields in Red are the Values from "Field_Type", these are not Fields.

So Do you want me try as below?

Count({$< STEP = {'VAL'}, Field 2-= {'Amount helper'}, Result -={'NA'},Field_Type=>}[Registration ID]) /
Count({$< STEP= {'VAL'}, Field 2 -= {'Amount helper'},Result -={'NA'},Field_Type=>} Total<UID, Field_Type > [Registration ID])

Thanks

Re: Pivot showing Percentage of row parent total without changing with filter in Row or Column

RC_121985 — Sun, 13 Feb 2022 04:21:48 GMT

Any other way to do this?

Re: Pivot showing Percentage of row parent total without changing with filter in Row or Column

RC_121985 — Tue, 15 Feb 2022 16:19:16 GMT

I some how got the result, But Not completely happy. I have set expression as below and for filtering Managed it with Vizlib Pivot.

if(GetSelectedCount(Result)>0,

(Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}[Registration ID])
/
Count({1< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}total<UID, Field_Type>[Registration ID])),

(Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}[Registration ID])
/
Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}total<UID, Field_Type >[Registration ID])))

If any one have any other solution please let me know. I want set analysis to Calculate the % even after Filter.

Till then setting this as a solution

Thanks,