2 Replies Latest reply on Mar 8, 2013 7:22 AM by Brad Llewellyn

    Calculation disregarding the Selection

    madhan.rajendran

      Hi All,

       

          I want to do a comparative analysis between the selected value sum with total sum of the measure.

       

      Example is the attached Workbook. I am having a Table of Week, Product and Order. I want to show a comparison of Selected Product total Order vs Total Order the week. I will have a Filter for Product. When I select the Product, the Weekly total Order for the whole data should be same Since it is same always for the particular week, but only the Selected Product Order should change where I can compare the selected Product Order Vs Weekly Order.    I guess I am not confusing too much!