Hi Experts,
i have the following data with Month names and the corresponding %. i have to build a chart/table with Month name as dimension and two expressions 1. Current Month % as it is 2. Previous six months average.
For example, if the Month name is September-2019, then current month % is 86.69% and Previous six months average should be 85.03%. can you please help me with the expression? i cannot do this in the data.
Input:
| Month Year | Current Month % |
| 01-2019 | 84.81% |
| 02-2019 | 83.94% |
| 03-2019 | 84.43% |
| 04-2019 | 84.51% |
| 05-2019 | 86.25% |
| 06-2019 | 85.86% |
| 07-2019 | 85.19% |
| 08-2019 | 85.07% |
| 09-2019 | 86.69% |
| 10-2019 | 85.50% |
| 11-2019 | 87.09% |
