Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have excel file like below.
Address ID Physician Nurse Pediatric
ABC 1 5 6 8
DEF 2 6 4 3
GHI 3 5 6 7
I need a bar chart with count for Physician,Nurse and Pediatric.
I have to group Physician,Nurse and Pediatric into one field.How can I do this ?
Thank you very much.
This may be?
Table:
CrossTable(Group, Value, 2)
LOAD *;
LOAD * Inline [
Address, ID, Physician, Nurse, Pediatric
ABC, 1, 5, 6, 8
DEF, 2, 6, 4, 3
GHI, 3, 5, 6, 7
];
Hi Pavana,
If I understand your requeriment, you should do something like this:
CrossTable(Merge, Data, 2)
LOAD Address,
ID,
Physician,
Nurse,
Pediatric
FROM
(ooxml, embedded labels, table is Hoja1);
That way, you can count by the Merge field.
Hope it helps.
Cheers,
Andrés
More like this Sunny T
Using your quick solution.
I agree with Andrés. Good idea!!!!
Or if you want a horizontal stacked bar char like this:
Do you want the groupshowing as a cyclic group?