6 Replies Latest reply: Sep 25, 2014 8:42 AM by Dae Han RSS

    Master calendar and Filtering problem

      Here is my problem.

       

      I have 2 sets of data that I call "purchase plan" and "Purchase actuals." With the data, I need to form a graph showing both in monthly basis as attachment shows. (please open and refer to the attachment)

       

      Those two have thier individual date fields, therefore, I had to utilize Master calender in order to have them on a graph.

       

      Utill this stage, everything was fine, and it worked GREAT! However, when I filter them by its type, it gave me a numbers which did not make sense.

       

      If I filter it by "Cal_Report_Prjname," it gives right number for Actual but not Plan.

      If I filter it by "Cal_Report_Prjname_2," it gives right number for Plan but not Actual.

       

      Can anyone please let me know how can I make a perfect filter that will give me a right number for both Plan and Actual?

       

      Thank you.