Help charting goal and sum dimentions

[kstroupe]

Hello,

Newby here.... I've attached a qvw to show my example:

1. I have a chart that calculates the percentage of a dimention. LTA vs No LTA (This appears to work).

2. I would like to place a goal line accross the months of 90% (This doesn't work) It only shows up if no YEAR is chosen and then only for months 07 - 07

3. I would like when I click on a either of the two colors for the dimentions (LTA / No LTA)  for my spreadsheet to change (this doesn't work) It only changes based on Month or Year chosen.

4. When no Financial YEAR and no Financial Month is chosen 2012 year has months with no data I would like those Months not to show (Current Selection would be blank)

[Josh_Good · Accepted solution]

I believe the attached is what you are looking for.

For the goal line I used a Reference Line on the Presentation Tab

I used only one expression:

Sum( REC_QTY*PCHASE_DOC_NET_PRCE_AMT)/ Sum(TOTAL < YEAR, MONTH> REC_QTY*PCHASE_DOC_NET_PRCE_AMT)

and then added a dimension for LTA_Flag and combined the year and month into one dimension.  Note I did combined Year and Month using a calculated dimension but it would be better practice to do this in the script.