2 Replies Latest reply on Jul 24, 2016 5:08 PM by daniel lim

    table calculation with grand total

    daniel lim

      Dear

       

      I tried to make one worksheet with measure values based on table calculation such as yoy and ytd as well as grand total.

      I used quick table calculation and last () function to show the value for the last month only.

      target image is as follows ('dashboard based' in attached workbook), but I want it to be 1 worksheet.

      If I tried to do it with 'Totals' menu, it just showed me long list of every month in worksheet as follows ('result' worksheet in attached workbook)

      I don't understand why it shows every month even though I used last() function to hide unnecessary months.

       

      Anybody help me please~

       

      Regards,

      Dan