I have a capital expenditure list. I want to display cap ex amount by company in a bar chart. when hovered over the tool tip should show total budgeted amount, total not budgeted amount, total IT purchase, total not IT purchase, total growth, and total maintenance for individual companies. i am struggling on making the tool tip work.
budgeted?: yes/no, IT purchase?: yes/no, and expenditure type: growth/maintenance are choice columns.