Challenge_4

Let say we have data like this

Month         Day      Product_Name      Stock_in_Inventory
January         1          Gadgets                    500
January         2          Gadgets                    600
.                     .               .                              .  
.                     .               .                              .
January         31         Gadgets                   600
February        1          Gadgets                   100
February        2          Gadgets                   200
.
.
February        28        Gadgets                    0
March             1         Gadgets                    700
March             2         Gadgets                    900
.
.
.
March            31         Gadgets                    1325


Case 1: In report level i am displaying month wise day wise stock in inventory.

Case 2: I create a parameter named as Day_Parameter

If i entered 1 it displays the first day of stock in inventory.

Case 3: If i entered 2, it displays the second day of stock in inventory.

Case 4: if i entered 31, it displays the 31st day of stock in inventory.

Case 5: if parameter is null, it displays the every month of last day of stock in inventory.

Please Subscribe to get new Notifications

If you crack the challenge send me the workbook or logic to this mail id: skrafi449@gmail.com