Finding row level % contribution

Hi Team,

please refer to the attached. I am using cross table calculation.

there are multiple phone numbers for our custmomers of which many are incorrect like format "9999999999". now there are like 45,009 types of phone numbers appearing.

Hence in the cross table i am searching for an option just like in excel i.e. column A value/ total value. For example: in the attached screen shot first phone number is :1234567890 with total count as 17338 and the total entires are 45,009 hence a new it show a new column with relative % of this number which is around 38.5%.

Please advice how can i achieve this.

Thanks, Shivi


Image icon calculation.png14.09 KB

(1) Answer