Bar chart

[Anonymous]

Hi All,

I need to show the bar chart of the sum of Projection amount month wise on below criteria

If the year is 2013 then use the projection 'OP' to count the Amount

If the year is >=2014 then use the projection 'B Q4' if not exits then use B Q3,  if not then B Q2, if not then B Q1 to count the Amount

Attaching the data sheet. Please let me know if questions.

Thanks for all help.

Regards,

Ankit

[Anonymous]

Any answers please?

[#3]

Try this in your expression:

if( YRMON like '2013*',    count({< Projections = {'OP'}>} Amount), if(YRMON like '2014*', count({< Projections = {'B Q*'}>} Amount)))

[ecolomer]

Here you have your data, but wich is the question exactly ?? (sorry because my english is not good)

[MarcoWedel]

maybe this thread helps also:

Urgent Help Required

regards

Marco