Skip to Content
0
Former Member
Feb 19, 2011 at 06:13 PM

Pull unique result in RKF

22 Views

Hi all,

I have a query issue that I've been trying to solve.

I have a large query with many Calculated Key Figures that is sliced by Vendor. Each vendor has a Primary Material (navigational attribute of 0VENDOR) & a Cost (calculated key figure). My problem is, I need to pull the average Cost for all unique vendors with a the same Primary Material.

For example: if there are 10 Vendors with Primary Material X, I need to pull the sum of the Cost for those 10 vendors with Primary Material X. I then need to divide by 10 (vendor count), to get the average.

Can anyone suggest a way of doing this? I have a unique vendor count, but I am having trouble pulling the Primary Material component into an RKF or CKF.

Thanks for your help! Points awarded.

-CLM