Chart Running Totals

[mtownbound]

This is the data that I have:

Daily count of sneakers sold
Daily count of sneakers sold to men
Formula field that shows daily percent of sneakers sold to men
“If sneakers sold > 0 then (sneakers sold to men % sneakers sold) else 0 ”

Running Totals grouped by month
Total Sneakers sold
Total Sneakers sold to men
Formula field that shows daily percent of sneakers sold to men
“If sneakers sold > 0 then (total sneakers sold to men % total sneakers sold) else 0 ”


Need a line chart showing sneaker sold to men average by month (Chart the formula field from the running totals)


Thanks!!!!!