Converting Value to Percentage per Columns

[KamenRider]

Good day,

I have a data in columns and would like to find its percentage per month. To get the percentage, for example under Jan 22, 220/338 = 65%

I would to create another table having its conversion to percentage. The result should be as follows:

Please advise how can we convert it to percentage.

Thanks and looking forward for your assistance.

Kamen

[OllieClarke · Accepted solution]

Hi @KamenRider 

Here's how I would approach this - N.B. I made up my own numbers, but the approach is valid

Starting numbers: 

[BS_THE_ANALYST]

@OllieClarke I've snagged your data, just wanted to throw another idea out there. In the cross-tab, we have 'Percent Column' as the aggregation method:

Then a little tidying by removing column prefixes with the select tool + multi-field to concatenate the % symbol:

Have a great weekend!

All the best,
BS

[KamenRider]

Thank you @BS_THE_ANALYST amd @OllieClarke  for the sharing. One thing I learned from this is the use of crosstab and transpose which I seldom used. Thank you so much for helping me to solve this problem.

Until Next.

Kamen