14 Replies Latest reply on Sep 11, 2019 9:32 AM by Abdul Munaf

    Current Year and Previous Year Orders

    Gaytri k

      Hi team,

       

      I have a requirement to show number of orders for 2014 (Total orders per month) and 2015 orders.

       

      I the table visualization, i have added a "Category" filter which filters the orders per category.

       

      I have created a "2014 orders" which is a LOD

      what i need is :  when all is selected in "Category" filter, the LOD shows all fixed 2014 orders in the view like below:

       

       

      But when "Technology" is selected from "Category" filter, I can see missing LOD values for February like below:

       

      Im expecting 7 in Feb.

       

      Can anyone suggest me how can i get that in the visualization?

       

      Sample attached