I have attached a packaged workbook with the worksheet setup to get the answer I am looking for.
I am trying to use the formula in "No Movement Store Count L4W along Store" at the store level, but sum at weekly level. If I move the "Store" out of marks, the measure calculation says it needs a field. I know we cannot use LOD and table calculations, so I am trying to get around that.
My goal is to calculation "No Movement Stores" by assigning a 1 to a store for the week/item when: Order On = 1, Inventory >1, Sum L4W>0. Then, I want to count those stores for the week/item.
Thanks for any help!
Could you please attached a copy of your workbook,
but with an extract made from your Access datasource?
For us (community fellows with the Macs) to be able to help.