This discussion is archived
7 Replies Latest reply: Feb 12, 2013 11:08 PM by 969883 RSS

Displaying Selected + Prev. Year Data (Parametric)

969883 Newbie
Currently Being Moderated
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.

Thanks!

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points