Mini Chart in Limit Dimension Issue

[#1]

i have two Dimension in a Table State and City, i have put a limit Dimension on City i.e.

i have also created a MINI Chart in last of the table column in which i want to show the trend of the T/o.

when i remove limit Dimension formula its show trend in all city. but when we put the Limit Dimension back is show me blank few City.

the Trend Dimension is MonthYear.

trend Formula:

(Sum({<MONTHYEAR=>} TRADE_VALUE)/sum({<MONTHYEAR=>} TRADING_DAYS))

[Anonymous]

Are you sure your formula is correct?

For me it should be like this:

=(Sum({<MONTHYEAR=>} TRADE_VALUE)/count({<MONTHYEAR=>} distinct TRADING_DAYS))

[#3]

Hi Balraj,

Formula is Correct because i have a table where i have keep MONTHYEAR, TRADING_DAYS for example.

MONTHYEAR,      TRADING_DAYS

NOV-2015,           20

for Daily Avg Calculation i have to do like this only.. other place i am doing this way only..

Its a just matter of deriving value...

[#4]

Even if i do only SUM() then also facing the problem. but when i remove the Dimension Limit its working fine.

[Anonymous]

okay, so what dimension limit you are trying to achieve?

[Anonymous]

On State & City what restriction you want to apply?

[#7]

Already Mention the on the First Post along with the screenshot

[Anonymous]

did you try with suppress with null option for City Dim?

[ajsjoshua]

Hi,

Make Mode:Sparkline

click Supress when value is Null.

[#10]

Already check that no problem with that... I think it is related to Limit Dimension only because when i remove Limit Dimension its showing mini Graph for all city.

Image After removing Limit Dimension.... Now it showing all