Hi all,
If there is a better way of doing this let me know. This is what I have so far and I need a bit of guidance to see if I can do this. I have a cross tab query that displays the value of an order over time (accounting periods). I want to see if the order value changes over time and call out those values which to do change.
Here is how I think I can do it, but I need help with the construction. I would add another row with an countif expression. This expression would count how many of the values matched the most recent value. For example
Order Month 1 Month 2 Month 3 Countif
1 50 45 45 2
2 10 10 10 3
3 75 60 50 0
Any suggestions on how to improve or construct this would be appreciated.
Brennan
If there is a better way of doing this let me know. This is what I have so far and I need a bit of guidance to see if I can do this. I have a cross tab query that displays the value of an order over time (accounting periods). I want to see if the order value changes over time and call out those values which to do change.
Here is how I think I can do it, but I need help with the construction. I would add another row with an countif expression. This expression would count how many of the values matched the most recent value. For example
Order Month 1 Month 2 Month 3 Countif
1 50 45 45 2
2 10 10 10 3
3 75 60 50 0
Any suggestions on how to improve or construct this would be appreciated.
Brennan
