Making a Chart or TableBox filter for a specific value

[#1]

Hi,

I'm trying to make a chart or tablebox display only specific values as in the sql 'where' statement e.g. I want to show all the values for a specific year / month in on box e.g. Jan 2010 in one and then Feb 2010 in the next (In reality the year will be picked elsewhere)

or. Can I do the same for columns, like Sales / Quanity for Jan, Sales / Quantity for Feb ansd so on.

Thanks

John

[brenner_martina]

Hi,

you can enter a dynamic dimension like: If(year=2011,year)

and in the expression enter:

Sum(If(year=2011 And Month=1, Sales)

[#3]

Hello Jhon,

Please take Month_Year as dimension and Sales , Quantity etc in Expression .

It will show all the sales , Quantity for the Month_ Year Wise as in your calender.

[#4]

Works in part, but not as hoped.

Maybe looking at it as showing summary values by month by customer may help

Thanks

John

[suniljain]

you can also write expression in dimention .

so that your dimention value dispalyed for selected parameter.

[suniljain]

Dear John,

you can also group by sales on Year,Month basis . it will solve your problem

[marcohadiyanto]

hi,

you can create bar chart and make "YearMonth" as dimension and Sales/Quantity as Expression.

then it will give you chart for comparison between year and month and will given value from sales/quantity.

regards

[#8]

This is what I've done. Its not ideal but the user is totally happy now (users are strange)

Thanks all for your help