I have a crosstab that has daily totals for each sale_type and a final total for each sale_type for each city.
CITY DATE SALE1 SALE2 SALE3
Boston 01/01/17 11.11 0.00 22.22
01/02/17 44.44 88.88 77.77
Portland 01/01/17 10.00 70.00 90.00
What I want to do is to put the city totals (Boston SALE1 55.55, SALE2 88.88, SALE3 99.99 & Portland SALE1 10.00 SALE2 70, SALE3 90.00) into a bar chat
I dont know what values to use for VALUE, LABEL, CATEGORY or SERIES nor am I sure what bar chart style to use.