5 Replies Latest reply on Sep 7, 2016 11:05 PM by lei.chen.0

    bar chart shows latest date with a point showing change from last period

    Yashar Tarverdi

      Hi there,

      I want to show a bar chart of last date (let’s say I have just yearly data and then this will be my last year) in my data with a point shows its change (not percentage change) from the year before.  So I created a calculated field with

      Lookup(sum(sales),-1)

      But because I want to have the latest year I had to filter the date (top 1 maximum date) and as you know filter applies first and then nothing shows in calculated field. I was thinking about LOD but not sure how to apply it here.

      Here is the file.

       

       

      I will appreciated your feedback.