Hello Everyone, I am trying to make a chart.

[#1]

I am Trying to make a chart whose table is like:

Year	Month	MoneyMeasure	Qty
2009	Jan	20,000	A
2009	Feb	21,000	B
2009	march	22,000	C\

this table is increasing for all months of 2009,

all months of 2010,

all months of 2011

So i need to make a chart for all qty for all months of year 2010.

So my chart should see like as:

Dimension containing months (Jan to Dec) of 2010 year,

and expression would sum(MoneyMeasure) regarding each qty....

Please help.

Thanks.

[Anonymous]

I am not sure if I understood ur requirement clearly.

Sum({<Year={'2010'}>}Moneymeasure)

Sum({<Year={'2010'}>}Qty)

Regards

Erika

[nicander]

try a pivot table. dimensions year and month.

[Anonymous]

Hi,

From what I understood from your post you have to make a chart and: in the dimensions tab put this calculated dimension =if(Year = 2010, Month) and in expression tab put this expression Sum(Aggr(Sum(MoneyMeasure),Qty)) with this label ='Total'  & Sum(TOTAL MoneyMeasure) to calculate the total sum of MoneyMeasure.

Hope it helps.

BR,

CA

[#5]

Hii Alexandru,

thanks for reply,

I have a case in this chart that this chart will change its value according to my year selection, and that year is stored in a variable called vPriorYear as =Num(year)-1

That means need to calculate the selected years prior year value of qty.

I am writing this dimension like

=if(year=$(#vPriorYear),Month) this is showing error in calculated dimension.

[er_mohit]

use Pivot chart

Dim Year,Month

expression

sum({<Year={"$(=Year)"}>}Qty) 

when you select any year then it 'll show you result

hope it helps

[#7]

Hi,

Don't use calculated dimension for your requirement,

You just use your Year and Months as your dimensions and use the below expression.

  sum({<vYear = {'$(=Max(vYear)-1)'} >} vSales).

See the attachment for your reference.

[#8]

Hi Nupur,

It is very simple to achieve such functionality. You just need to change you expression a little bit.

intead of using sum(MoneyNeasure)

Use this:

Sum({<Year={'2010'}>}MoneyMeasure)

This expression will apply the filter for 2010 and displays the values of MoneyMeasure related to year of 2010 only.

[#9]

Hi Venugopal,

Thanks, your answer helped me a lot.

[#10]

Thanks Hannan Tariq,

Able to make the chart .