Help with 2 Issues

[#1]

Good morning,

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

[rohit214]

HI

try this

1)day(dateField)

year(dateField)

month(dateField)

2) If(Stock in Sistem=StockCount,Count(Distinct item),0)

may it helps you

please let me know

thanks

rohit

[kamalqlik]

Hi friend....you can applly the following logic

1.Day(Count Date) as Day

2.Month(Count Date) as Month

3.Year(Count Date) as Year

4.monthstart(Count Date) as Monthstart.

regards

kamal