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