Hi All,
I am currently working on showing profits for my store into a line chart visualization for 2023. I want to be able to represent this in a line chart and represent three levels, the whole store, the departments of the store and the centers in each department. I want it to show the profit of the whole store, drill down and show the profit of each department, and then drill down and show the profit of each center in each department. Here is some sample data:
| | | RSS HV | RSS SIM | RSS LV | T&D LV | T&D HV | VSS TRM | VSS NON-STD | VSS ROBOTS | BEARING SEALS | METAL | SSI | P&D THERMAL |
| Calendar Year/Month | | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| 01/2023 | JAN 2023 | 100,000.00 | 0.00 | 10,000.00 | 15,000.00 | 100,000.00 | 0.00 | 10,000.00 | 15,000.00 | 0.00 | 100,000.00 | 0.00 | 10,000.00 |
| 02/2023 | FEB 2023 | 110,000.00 | 0.00 | 11,000.00 | 16,000.00 | 110,000.00 | 0.00 | 11,000.00 | 16,000.00 | 0.00 | 110,000.00 | 0.00 | 11,000.00 |
| 03/2023 | MAR 2023 | 120,000.00 | 0.00 | 12,000.00 | 17,000.00 | 120,000.00 | 0.00 | 12,000.00 | 17,000.00 | 0.00 | 120,000.00 | 0.00 | 12,000.00 |
| 04/2023 | APR 2023 | 130,000.00 | 0.00 | 13,000.00 | 18,000.00 | 130,000.00 | 0.00 | 13,000.00 | 18,000.00 | 0.00 | 130,000.00 | 0.00 | 13,000.00 |
| 05/2023 | MAY 2023 | 140,000.00 | 0.00 | 14,000.00 | 19,000.00 | 140,000.00 | 0.00 | 14,000.00 | 19,000.00 | 0.00 | 140,000.00 | 0.00 | 14,000.00 |
This data right now is the profit of all the centers in the store. If I add up all the centers that consist of each department I can show the department profits (i.e., adding all the RSS centers will give me the profit for the RSS department). If I add up all the department profits that will give me the store profit. I want the store profit to show with the dates on the x-axis and the profits on the y-axis and then I want to be able to drill down and it will then show the department profits. Finally, I want it to be able to drill further down to show the profits of each center. How could I do this?
