This content has been marked as final. Show 2 replies
I'm ussing a personal edition and I'm trying to build a pivot table to show the inventory accuracy, let me explain my two issues:
1.- I have a Oracle DB that have a fiel call Count Date in DD/MM/YYYY
I want to separate it in Days, Months and Year in order to use it like a Dimension, but I don't know how.
2.- In order to calculate the Inventory accuracy, i have 2 level to do it.
. For Item - I'm ussing two field "Stock in Sistem" and "Stock Count" and this work fine.
. For Item Family - I woul like to know how many Items are right, using
Count(DISTINCT(If(Stock in Sistem=Stock Count,Item))) This Work some time but not in all case.
see attached my app
Could someone help me with it please