Pivot Table

[maniram23]

Hi experts,

I am trying to do in pivot table as i am not getting the exact output,

my logic is TAT should be" >7 " and the value should be carry forward.

Please check the attached file  1. Sheet 1- Input

                                                  2. Sheet 2 - Output (Required)

Regards

[Anil_Babu_Samineni]

May be try like below

1) Pivot table

2) Dim - R/O Date and Center

3) Measure

4) Drag column to Row on top of chart for Center. you will get it

[dineshm030]

Hi Mani,

The Output data is sample or original value??

[maniram23]

Hi Dinesh,

that is original value.