4 Replies Latest reply on Nov 8, 2018 11:32 AM by Amyl

    Fixed Calculation and filter issue

    Amyl

      Hi

       

      i am having issue with workbook,      which shows Target,sales and profit for four regions but i would like to see Target range as constant even if we change any other filer on the sheet.

       

      Example: on the bar graph

       

      Central: Bar Graph contain Target, Sales and Profit : Target for central is 751860,Sales is 501240 and Profit is 39706 If i un-chek any options on the filters Target is effecting and target is changing for the region.

       

      Goal is: i should be able to use subcategory,Manufacturer and state filters but these options should not influence Target bar, Target is constant for each and every region.

       

      Please find attached workbook and guide me.

       

      Thanks

      Amy