12 Replies Latest reply on Feb 13, 2019 5:43 AM by Norbert Maijoor

    Current Period v Previous Period

    Helen Rowson

      Current period v previous period. In the attached workbook I’ve created a table calculation to give the percentage variance of the current period v the previous period.  I only want to show the most recent period however for the table calculation to work I need to have the previous period on the sheet.  I’ve managed to make the text white so this works when I just show the percentage (see image in attached Word doc). HOWEVER: if I want to show as a ‘shape’ with the performance ‘improving’ or ‘deteriorating’ arrows I can’t get it to show only the most recent month… the shape shows for the previous month too.  The shape highlighted in yellow in the Word document I don’t want to be visible.  Thank you in advance for any help you can give me!