7 Replies Latest reply: Feb 13, 2013 1:08 AM by 969883 RSS

    Displaying Selected + Prev. Year Data (Parametric)

      Hey all,

      I was wondering if you could show me a couple of different ways to display data from several different subsequent years, for example, 2013, 2012 and 2011.

      I can do it "hard-coded" like this:

      FILTER("Fact Invoice Detail"."Price"/sum("Fact Invoice Detail"."Price")*100 USING ("Dim Month Invoice"."Invoice Year" = 2013)) ----> use the same formula for 2012 and 2011.

      This gives me the Price values in percentages for the year 2013. I tried to make this accept a Presentation variable from a Dashboard prompt (the user selects 2007 and gets the values 2006 and 2005), but it didn't work. Unless hard-coded, BI seems to display only the data for the year selected with the Dashboard prompt...

      Hope this made some sense; it is a bit confusing to explain in writing.


      Edited by: 966880 on Feb 11, 2013 5:44 AM