Converting Value to Percentage per Columns

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

Workflow

Common Use Cases

Preparation

Accepted answers

OllieClarke

Hi @KamenRider

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

Starting numbers:

% from Date.yxmd

All comments

OllieClarke

Hi @KamenRider

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

Starting numbers:

% from Date.yxmd

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

% from Date_Ollie_Clarke.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703