1 Reply Latest reply on Oct 9, 2013 8:04 AM by Matt Lutton

    Month on month growth metrics uaing parameters to select metric

    Dixon Hayley


      Hi,

       

      I have an issue in that i'd like three different metrics to display growth rates month on month in a table. However i'd like these three metrics to be selectable from a parameter in order to display value growth, volume growth and active card growth.

       

      i have created the seperate calculated growth fields with the following formula which works well when pulled into the table:

       

      (ZN(sum([Value]))-lookup(zn(sum([value])),-1))/abs(lookup(zn(sum([value])),-1))

       

      However when i create a parameter calling on my three calculated growth fields, no values display so the parameter doesn't work.

       

      Is there a workaround that anyone knows of?

       

      I just need a parameter that allows metric selections of growth rates month by month.

       

      Thanks,

       

      Hayley