Hi,

I have a pivot built from Powerpivot which gives me an average sales value across a range of products. Each product belongs in a product 'family'. I wish to add a KPI measurement to track performance but each family has a different absolute target - can this be done - work book link below and as always thanks for any advice.

https://onedrive.live.com/redir?resid=3AE8882B3E11F58%21118

This resource may be helpful: http://msdn.microsoft.com/en-us/library/hh272050%28v=sql.110%29.aspx

Hi,

I have figured this out now - didnt want anyone spending their time on it now I have it.

• Marked as answer by Grinch356 11 hours 15 minutes ago

Hi Grinch,

It seems that your issue had been solved by yourself. Could you share the solution so that it will help other forum members who have the similar issue.

Regards,

Hi,

I have figured this out now - didnt want anyone spending their time on it now I have it.

• Marked as answer by Grinch356 Tuesday, January 06, 2015 12:15 AM

Of course,

I imported a separate table with each KPI on it and linked it to my results table. This way I was able tolink each specific target to the specific result by setting them both as measures.