10 Replies Latest reply on Apr 20, 2018 2:58 PM by Jeff West

    Multi dimension calculation.  Level of Detail?  Set?  Other?

    Jeff West

      I am attempting to create calculations based on 3 different dimensions and 1 measure.  Project, Part Number, Mfg PN, Price.    For each project I need to know the % of Part Numbers that are unpriced, where there are potentially multiple MFG PNs for each PN that may have a price.  I want to know which PNs do not have price for any/all of it's MFG PNs (include zero and null).

       

      Calculations as it would be in excel are in attached example.  I can't figure out the best (or any) way to do this.

       

      Jeff West

       

      Legal Disclaimer :

      The information contained in this message may be privileged and confidential.

      It is intended to be read only by the individual or entity to whom it is addressed

      or by their designee. If the reader of this message is not the intended recipient,

      you are on notice that any distribution of this message, in any form,

      is strictly prohibited. If you have received this message in error,

      please immediately notify the sender and delete or destroy any copy of this message!