% contribution

Question & Answer
,
1

Hi Team,

We have list of data in column 1 ( example XYZ, ABC,XYZ,LFN,IJP,ABC), this might be repeated as well based on the occurrence. In column 2 we have number allocated to column 1 data(example 1,2,1,3,2,1,4).Here we are trying to calculate the contribution for each data set in column 1 How to do the same?
Example table :-

Label Count
ABC 1
XYZ 4
ABC 2
LMN 1
IJP 2
LMN 2

Contribution of ABC = ABC count /TOTAL count of column 2
=(3/12)*100
=25%.
Contribution of XYZ,LMN,IJP.

Which formula will calculate all unique data set in column 1 and give contribution?

2

Hello @nandu - Please see the below snapshot where I have tried to outline how you can implement it. Hope this helps!

image
image1818Ă—450 34.2 KB

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

2 Likes
3

I will check and get back soon.

4

image
image1055Ă—196 10.7 KB

Getting below error while adding calculated field-Contribution.

5

@nandu Is Count also a derived field in your case? If you see the expression that I shared, Count is a base field. Can you please share your dataset sample. I replicated the scenario based on the example dataset that you shared and it works fine.

8

It is working and thank you so much for the support.
I used derived field in contribution calculation and it worked.

1 Like