Cross tabulation row percentages

1 visualizzazione (ultimi 30 giorni)
Sarah Yun
Sarah Yun il 31 Dic 2019
Modificato: TADA il 31 Dic 2019
Hello,
I have a table with 4 columns and 5 rows
I want to display the row values as percentages
example
date sale 1 sale 2 total sales
1989 4 (x%) 3 (x%) 7(x%)
7 would be 100%
now express 4 and 3 in terms of 100%?
How to do this for my table in matlab?
Thank you.

Risposta accettata

TADA
TADA il 31 Dic 2019
Modificato: TADA il 31 Dic 2019
How about something like that?
t{:,{'sale1','sale2'}} = t{:,{'sale1','sale2'}}./t.totalsales * 100
Given that t is your table, or a copy of that so you don't override your original data

Più risposte (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by