Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any answers please?
Try this in your expression:
if( YRMON like '2013*', count({< Projections = {'OP'}>} Amount), if(YRMON like '2014*', count({< Projections = {'B Q*'}>} Amount)))
Here you have your data, but wich is the question exactly ?? (sorry because my english is not good)