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
Solved! Go to 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:
@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
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