Month ('F17 P01'; 'F17 P02'... 'F18 P01' to diffenciate the different months of reporting, so one employee has as much records within the dataset as much months of service he or she has)
My questions are:
1) How do I create a matrix that shows only the female representation (%, 1 decimal) of the total headcount by Market and which I can filter by Month and any other possible variable that I add as a filter?
2) How can I add a column to the matrix above which shows the difference between the measure and 6 months prior's data? (So if I selected "F17 P07" on my filter I would see F17 P07 female % on the first column and the difference between F17 P07 and F17 P01 numbers?
Thank you very much for all your help in advance, it is very much appreciated!