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



      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.