8 Replies Latest reply on Jul 5, 2018 1:29 PM by peter.shindler

    Find Avg from Data Ignoring a Dimension NOT In Use

    peter.shindler

      Hi all,

       

      I don't think this is a difficult problem, but I've tried everything I can think of (ie EXCLUDE, FIXED, some very clunky Calculated Fields) with no success. I've got payout data for several sales reps for 3 products, and I'd like to show the average payout per rep (ignoring the individual products). Since "Product" isn't in use, EXCLUDE isn't doing anything. The average should be $10,245; I always end up with $3,415, which is the average per rep per product. Packaged Workbook is attached, created using 2018.1.2. Any ideas? Thanks for any help you can give!