5 Replies Latest reply on Dec 8, 2016 5:06 AM by asim cholas

    Displaying Data Labels for the latest Month

    user13483708

      Hi All,

       

      I have a Pivot table where horizontal axis is Month ,vertical axis is Brand and revenue as measure and have a line graph created based on the pivot table. what I did is Opened Chart Properties -> Title and Labels - > Data Markers -> Display Options -> Show Data Labels ->Show Always. So what happening is its displaying the revenue values at different monthly points.

       

      What my requirement is to display only latest month revenue figures  and suppress all other revenue data markers??. Thanks in advance

       

      Thanks

      Raj