3 Replies Latest reply on Sep 24, 2018 6:32 AM by ShivaRam Chennapragada

    Filteryng by two year

    Ilya Varnavskiy

      Hi,

       

      I have simple sheet with column dimension "Year" and row dimension "Account" and  sum of money as data grouped by year and account.

       

      I want make filter  with selection only one year. But view must show two column - data in selected year and in previous year.

       

      I made calculated dimension "=YearID-1" and placed it into Columns, but without good result.

       

      Is there a way to solve my problem?

       

      Thanks!

       

      tablo2.png