Hello Folks,
I have below requirements need to accomplish through Tableau. I have data from Nov to Oct. My fiscal year start from Nov and ends Oct.
Expecting: I wont dynamic dimension for Actual and Forecast Months to separate like below.
Please note, Based on Business requirements, I need to adjust Actual's and Forecast months.
For Instance, Actual Ends on April and Forecast start at May in some cases.
Please suggest work around for this kind of issues. Attached working file for reference.
ActualForecastEmployeeNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberA-037222202342021A-077443535235345A-081203245222414B-002254152303120B-031-II121814141414151315141216B-062-II121714121616161812121816B-066034452500201C-001-II151414141414131817141318C-015521535213311C-025-II141517131718171712151717C-040215045352114C-041-II161618181515151717121817C-053132550210451C-054352544230555D-005334053235102D-019552300441250D-026540202531002E-022313343420323E-029455124035453E-030412211035502E-038224104025022E-046-II151712131417161414181316E-055401213414021E-075-II141214171615181614171213E-087-II131614171317181313121316E-096202044533054
the Tableau Reshaper Toll Add-in for excel might help you re arrange the data( Using the Tableau Reshaper Tool To Format Your Data for Vizable )
