2 Replies Latest reply on May 30, 2016 5:06 AM by Philippe Verhaeghe

    Calculations including/excluding filters

    Philippe Verhaeghe

      Anyone having done this kind of calculation ?

      I have a set of quick filters in my view : Year, Category, Sub-category and Ship Mode.

      Once I have selected the desired values, I would like to calculate the % of customers filtered by Year/Category/Sub-category/Ship Mode relative to the number of customers filtered by same Year/Category/Sub-category (so not taking into account the Ship mode filter).

      For example, from the Sample Superstore dataset, with filters set to Years=All, Category=Furniture+Technology, Sub-Category=Copiers+Phones, ShipMode=First class+Second class, for T1, the expected value would be 51/124 (41%).

      Example Workbook is attached.