Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hope below expression helps
=Sum({$<Month={Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep}>} Goal_Metric)
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
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
Try with Quentin's solution, using Dimension limits you can limit to only 9 rows
in the Dimension change [Month] to If( Month >= 9 AND Month <= 11, Month, NULL())
Check "Suppress When Value is Null"
Hi Sharon,
Month is not my dimension its a filter
hmm.... can you attach a example??
You should have a dimension with months otherwise you should make one for each month