none
KPI Status as a filter?

    질문

  • Hi,

    I have created a KPI with SalesAmount P3M (previous 3 months/3) as Target for a company which distributes movies/DVD, I'm showing Repetoire (Action, Drama etc) and then SalesAmount and KPI. It's working fine. Now I would like to create a new pivottable with Movies/DVD where KPI Status = -1, is that possible?


    Larra

    2012년 3월 13일 화요일 오전 8:26

답변

  • Larra,

    It would be better to consolidate the information in a calculated column. If this is not possible due to business rules, or because you need dynamic calculations, it can be done but it is a little tricky.

    If you share the workbook, or a sample with some data, I will play with it a bit, it sounds like an interesting scenario. :)


    Alberto Ferrari
    http://www.powerpivotworkshop.com

    2012년 3월 13일 화요일 오후 8:44

모든 응답

  • Larra,

    It would be better to consolidate the information in a calculated column. If this is not possible due to business rules, or because you need dynamic calculations, it can be done but it is a little tricky.

    If you share the workbook, or a sample with some data, I will play with it a bit, it sounds like an interesting scenario. :)


    Alberto Ferrari
    http://www.powerpivotworkshop.com

    2012년 3월 13일 화요일 오후 8:44
  • Alberto and others,

    It's possible to do by using a value filter by Company/REpetoire for SalesAmountStatus (the KPI) = -1. It's working like a dream!


    Larra

    2012년 5월 9일 수요일 오후 5:54
  • Hi Alberto,

    What if I need to show the KPI's status on a slicer ? Is it possible ?

    Many thanks :)


    • 편집됨 Oren T 2013년 8월 1일 목요일 오후 12:14
    2013년 8월 1일 목요일 오후 12:14