1 of 1 people found this helpful
Find my approach as reference below and stored in attached workbook 10.1
a. QCM: if DATEDIFF('month',[Order Date],#1-12-2015#)=0 THEN [Q] END
b. QPM: IF DATEDIFF('month',[Order Date],#1-12-2015#)=1 THEN [Q] end
c. QMPY: if DATEDIFF('month',[Order Date],#1-12-2015#)=12 THEN [Q] end
#1-12-2015# could be replaced by today() when datasets constains current year
Current vs Previous Month: IF sum([QCM]) > sum([QPM]) THEN 'Up' ELSE 'Down' END
Current vs Same Month Previous Year: IF sum([QCM]) > sum([QMPY]) THEN 'Up' ELSE 'Down' END
The individual column formatting is explained here
This is great thank you so much.
Am busy going through it and mastering all the steps.
Your calc's were so much simpler to mine, so thank you again its been a huge help.
Take your time and let me know the outcome.
Glad I could help out. Thanks for the HUGE Awards!:) Much appreciated
As you can see from the result below
The outcome is a success. You might notice that my arrows are different to yours. I found that when you edit the shape, you can choose the arrow palette and at the bottom of the palette there are two arrows, red and green.
By Choosing these we then don't need to edit the colour as well in the table.
Thank you again for the help. Its exactly what I needed