In the below example I need to SORT the data based on date.
Visual : Maintenance Cost
X-Axis : Year & Month are text data.
RELATION : The Date fields in MAINTENANCE data and master table MONTH_YEAR are related.
Help me to sort the data.
Solved! Go to Solution.
Ideally the relationship should be from the Date column of Maintenance Cost and KPI MfgExp Table to the Date column of the Calendar Table. From the Month column of both Tables, we should be able to create another column in each Table with proper dates. The benefir of this approach will be that you will be use Date/Time Intelligence functions with ease.