Set analysis task

[#1]

Based on calendar object selections...it will show all years in one bar chart and  it will show particular years in another bar chart.

for example if i select 2011 in calendar object ...in one bar chart all months should be appear and in another bar chart jan,feb,march,dec..these  particular moths should be appeared.

[Gysbert_Wassenaar]

In the chart that should show all years change the expressions to overrule the selections in the year field. For example sum(Sales) would become sum({<Year=>}Sales) if you want to ignore selections in the field Year. Sum({1}Sales) would ignore selections in all fields.

[sushil353]

Hi,

you can use drill down option in dimension.

Create a drill down group for Year and Month and then use that drill down dimension in dimension.

HTH

Sushil

[Anonymous]

the second Chart should use a calculated dimension

if (Macht(monthfield,'jan','feb','march','dec')>1,monthfield)

why do you want those specific months?

maybe a flag would be easier to hanlde in script?