1 Reply Latest reply on Sep 25, 2018 9:06 AM by Deepak Rai

    Create a sum of vendor cost from a certain treshold only

    Christian Geuer

      Hi,

       

      I want to sum cost for different vendors (dimension) depending on a certain cost treshold per vendor. The treshold is a parameter, based on on the cost incurred (measure).

       

      How can I create calculated field that returns the sum of all vendors (# of vendors /sum of total cost) for e.g. only vendors with cost > $50.000?

       

      Thanks a lot for kick-starting my brain.

       

      Chris