Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Urgent- Creating new column with value

Hello ,

 

I would like to create a new column which returns only the value for "TDC " which is part of the element of the "KPI" colum.

best regards, 
Kerrout 

Need Help
Show and Tell

6 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Anonymous it's hard to see in the screenshot. Can you share the file/samle data
    Also create a pseuodo column of the result you want to get (just enter the values).

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago
      KPIPeriod TypeClusterSub-ClusterMarketCategoryBusiness AreaNUMDen% of NNS Pseudo 
      TDC2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma7766,07250,044631,05874 31,058
      Raw2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma2582,938514,04465,024735 0
      Pack2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma0514,04460 0
      Purch. 3P2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma-0,9082514,0446-0,00177 0
      Var. Man. Exp.2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma4792,603514,04469,323322 0
      Purch. 3P IG2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma0514,04460 0
      COGS IG2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma7,2656514,04460,014134 0
      Exports2022 YTD - 05AimmuneAimmune PPALAimmune PPALPharmaPharma0514,04460 0
      Cash Discounts2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma73,56471718,32580,042812 0
      Bad Goods Allow.2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma206,16281718,32580,119979 0
      Distribution Allow.2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma227,05151718,32580,132135 0
      Commission to Cust.2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma01718,32580 0
      Consumer Price Reductions2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma634,8361718,32580,36945 0
      TTS2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma610,31453396,69040,179679 0
      GGLF 3P2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma01718,32580 0
      MC2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma926,37011718,32580,539112 0
      VDC Tot2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma19,07231718,32580,011099 0
      DC2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma32,69541718,32580,019027 0
      DC Int2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma27,24621718,32580,015856 0
      MGE2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma12635,871718,32587,353594 0
      MGE Int2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma12635,871718,32587,353594 0
      OGE2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma14864,611718,32588,650634 0
      OGE Int2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma11170,031718,32586,500528 0
      OP22022 YTD - 05US Total PalforziaPalforzia USPharmaPharma-478371718,3258-27,8393 0
      TDC2022 YTD - 05US Total PalforziaPalforzia USPharmaPharma343,93891718,32580,200159 0,200159
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Here is the data, i would like to have a column which returns the TDC for each different cluster