1 Reply Latest reply on Nov 22, 2016 9:20 AM by Tom W

    How to get data to display 2 filters?

    Jagdeep Bhogal

      Hi all,

       

      I have a set of data that I need to display as filtered by 2 factors i.e. Life stage (e.g.Young people) and Car Model (e.g. those driving a Suzuki Swift)

       

      The problem I'm having is that parts of my data that are created from calculated fields don't seem to be factoring in both filters when calculating the figures. When I only use 1 filter on all of my worksheets, the numbers add up fine and the calculated fields work fine, but when I use both filters, the numbers don't add up and it seems like the calculated fields don't seem to be taking both filters into account.

       

      Does anyone know how to get data and calculated fields to factor in multiple filters when calculating numbers?

       

      Thanks

       

      Jag