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
{Sum(if Cost >50 Then cost End)}
This will return for entire dataset
If you want those vendor who have >50
{FIXED Vendor:Sum(if Cost >50 Then cost End)}
If this does not work, then we need some fake data and your expectation
Thanks
Deepak