set analysis

[rathnam_qv]

Hi all,

i have goal metric in my straight table which shows data for 12 months...but i want to display it for jan to sep

how can we achieve this can any one help me..

Thanks in advance!!!

Smiley

[sadickbasha]

Hope below expression helps

=Sum({$<Month={Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep}>} Goal_Metric)

[Anonymous]

Hi Rathnam

If you are using QV11, you can do it with the dimension limits options.

Go to your straight table properties, then to Dimension Limits and finally choose "Show only", "first", "9" values on your period dimension (10 if you want to show the last three months with the "Show Others" option.

Quentin

[rathnam_qv]

Hi Sadick,

if i use this..it is giving me the total amount for all months Jan to Sep..but it is not giving me individual month value

[sadickbasha]

Try with Quentin's solution, using Dimension limits you can limit to only 9 rows

[#6]

in the Dimension change [Month] to If( Month >= 9 AND Month <= 11, Month, NULL())

Check "Suppress When Value is Null"

[rathnam_qv]

Hi Sharon,

Month is not my dimension its a filter

[#8]

hmm.... can you attach a example??

[#9]

You should have a dimension with months otherwise you should make one for each month