4 Replies Latest reply: Oct 1, 2016 10:08 AM by john cena RSS

    Dimenssion limits comparing the current and previous months

    john cena

      Hi i have data

      Month           products   city

      Jan 2016       10              tokyo

      Jan 2016     25                newyork

      Jan 2016      45                brazil

      Feb 2016        30              hongkong

      Feb 2016       15               tokyo

      Feb 2016       20                newyork


      My requirement is i have a bar chart

      I'm calculating sum of products in a particular month

      I have applied dimension limits to it show largest 2 values

      In january it shows brazil and newyork

      In february it shows newyork and hongkong

      What i want is i want to compare the same values which are in january to feb ie in feb i want to see brazil and newyork but not newyork and hongkong


      Regards

      John