Skip to main content

 What I want to show is only the arrow up or down. Since my calculations are table calculation I don' believe this is possible but I need some help on the best way to show this. In the example I would only want the last row to be shown. This could be the current month or if there is no data in the current month I would want to show the previous month. I have attached a sample workbook

1 answer
  1. Oct 8, 2020, 8:55 PM

    We could not open the workbook you need to extract the data first then attach the twbx

     

    that said you can use a show/die filter to just show the last data see https://jimdehner2.blogspot.com/2020/02/faq-series-show-hide-filters.html

    for different ways to accomplish the goal

     

    If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote. 

    Also please help use better track your reply by including a mention to the volunteer who provided the answer  – mine is   @[Jim Dehner]​ 

0/9000