I need to create a visualization that allows the user to select a specific scheduled month. Upon selection, the visualization should display the corresponding months when the deliveries occurred.
For the given PO, The planned delivery to be happen in month of Aug 21 but the actual deliveries are happened after the planned Month. therefore, Now, The user wanted to understand in a visualization, month wise total planned delivery value vs how it is being delivered ? (in percentages) for the entire company level.
Note: we have both planned and delivered values in the same table and preferred chart is Pivot Table.