3 Replies Latest reply: Feb 23, 2016 2:47 AM by Settu Periyasamy RSS

    Need Help in Scripting

    Ramu Subramaniyan

      I have table like below basically I am doing recon between serverwise  daily

       

      Tab1:

      "A" server

      TransDate

      .

      .

      NetRevenue_Amt

      Inventory_Amt

      CostofSales_Amt

       

      Concatenate

      "B" server

      TransDate

      .

      .

      NetRevenue_Amt

      Inventory_Amt

      CostofSales_Amt

       

      Concatenate

      "C" server

      TransDate

      .

      .

      NetRevenue_Amt

      Inventory_Amt

      CostofSales_Amt

       

      I am creating the pivot as below

      TrasDate          A vs B             B vs C     A vs C

      (Dimension)

       

      I have  created three pivot for NetRevenue and Inventory and Cost of Sales. But I want create only one pivot with filter box as below

      FilterBox

      ------------

      NetRevenue

      Cost ofSales

      Inventory

      based on my selection  on filter box it has show the serverwise difference in pivot

       

      If I load it as crosstable I am getting value column as one field .is there any other way  to get value column has only in filter box so that I would have one piot

       

      T