6 Replies Latest reply: Jul 19, 2013 1:18 PM by kushal chawda RSS

    Weird Pivote table requirement

    Prasad Dumbre

      Dear All,

       

      We are having this particular req. at one of our client; They want to analyze week wise performance.

       

       

       

       

      WEEK 1

       

       

      WEEK 2

       

       

      TOTAL

       

       

      YTD

       

      CHANNEL

      SUB_CHANNEL

      CUSTOMER

      BUDGET

      TARGET

      ACTUAL

      BUDGET

      TARGET

      ACTUAL

      BUDGET

      TARGET

      ACTUAL

      BUDGET

      TARGET

      ACTUAL

      TOTAL

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      EBO

      Total

      100

      90

      95

      100

      105

      102

      200

      195

      197

       

       

       

       

      EBO-OR

      Total

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      W101

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      W102

       

       

       

       

       

       

       

       

       

       

       

       

       

      EBO-SOR

      Total

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      W103

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      W104

       

       

       

       

       

       

       

       

       

       

       

       

       

      On selection week only that week will be visible, Total will show the total value of all selected weeks; While YTD will show YTD value irrespective of week selection.
      Here we are facing a issue, we have done till total part but got stuck when in YTD part

       

      Any help would be appricated. . .

       

      Thank You.