1 2 Previous Next 22 Replies Latest reply on Dec 24, 2015 11:53 PM by kri shna

    Educational Brain Teaser : Fun with Measure Value Formatting

    Rody Zakovich

      Hello Community!

       

      We haven't had a Brain Teaser posted in a while, so I thought I'd give it a shot. 

       

      The Goal.....Add a KPI indicator to [Difference] => ( ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1) ), for all relevant values, and a N/A for the first partition.

       

      10-9-2015 11-15-53 AM.png

       

      Note that [Difference] is a continuous measure....

       

      As always, please rate on a scale of 1 - 5.

       

      Best regards,

      Rody

       

      Simon Runc want to kick things off?

        1 2 Previous Next