Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
hope one of you can help me with this
I have a pivot table with
articlecode current stock sales/month
1341012S `18 43
28
41
subtotal 112
What i want is that current stock turns red if the average sales for 3 months (when you select 3 months) is more than current stock
so: sum(sales)/3 > stock than RED
I have enclosed my document
Example code 1341012S
Current stock =18
avv. for month july/aug/sept = 37,3333 (=112/3)
stock should turn red, but it isn't
when you only select month june (where sales is >18) than it is working, so it seems my formula only looks at the sales and not at subtotal sales
Can someone help me??
Thanks
Can you upload ur file?
I have added a file in my original post
Daniele added this with my first question
When you select code 7194000 you can see stock = null
and box should turn red, but stays green
HI
Please check the attached file.
super! thanks
I added the Alt in the wrong place, but this works!
thanks