10 Replies Latest reply: Feb 17, 2014 10:37 AM by Paul Sokolik RSS

    How do I create a bar chart that shows current month gross sales amount, orders shipped and last year same month gross sales amount and orders shipped?

    Neena Bhattarai

      I am trying to create a bar chart that shows current month gross sales amount, orders shipped and last year same month gross sales amount and orders shipped? Currently I am trying to achieve it by using this:

      Gross Sales

      This month:

      Sum({$<[Ship Year]={$(=Year(today()))},[Ship Month]={$(=Month(today()))}>}[Gross Sales Amount])

      Last Year same month:

      Sum({$<[Ship Year]={$(=Year(today-1)))},[Ship Month]={$(=Month(today()))}>}[Gross Sales Amount])

       

      Orders Shipped

      (distinct if([Status]='Shipped',[Unique Order Key],null()))

       

       

      The problem with those expressions is that it only lets me see the current status for February if I click on any other month the bar chart says "No Data To Display".  How do I fix this?