I have a data set like this
Name Occupation Payment Principal Interest Amy Nurse 100 90 15 Becky Teacher 80 100 20 Catherine Nurse 90 75 15 John Engineer 90 80 12 Tom Teacher 120 100 20 ... ... ... ... ... I'd like to create side-by-side(Payment) stacked chart:
Row: Occupations Column1 : stacked(Sum of Interest and Sum of LP Principal) by occupation
Column2 : Only Sum of LP Payment by occupation
Can anyone help me with this?