I have data in multiple columns, one of the column has date details. I want something similar to pivot table for the date column based on segregate by "Cus Sgm"
While i am able to do this by Pivot, but i would want to do further segregate by:
- Current Month (as individual date wise)
- Next Month ( as consolidated by months)
- Next Year (as consolidated by Year wise
is this possible to derive
i have attached excel sheet with sample in sheet "Result"