Cross tabulation row percentages

2 visualizaciones (últimos 30 días)
Sarah Yun
Sarah Yun el 31 de Dic. de 2019
Editada: TADA el 31 de Dic. de 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.

Respuesta aceptada

TADA
TADA el 31 de Dic. de 2019
Editada: TADA el 31 de Dic. de 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

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by