Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

transpose vertical column to horizontal

Hi,   I want to transpose a vertical column to horizontal, but problem is that vertical column is calculated and I have more than one company and product. Sample data and result is like following. ...
Need Help
AnalyticPulse's avatar
AnalyticPulse
Icon for Solution Sage rankSolution Sage
2 years ago

can you post your sample data and expected result separately 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    Sample data is like this. M1 C/F and M2 C/F is the new column I want to get.

    Reporting AttributeSales UnitAttributeForecast MonthThis Month FCRemainderM1 C/FM2 C/F
    Car 1AAAMonth 011/1/20242   
    Car 1AAAMonth 012/1/20241122
    Car 1AAAMonth 021/1/20242   
    Car 1AAAMonth 022/1/202412  
    Car 1AAAMonth 031/1/20242   
    Car 1AAAMonth 032/1/202472  
    Car 2BBBMonth 011/1/20242   
    Car 2BBBMonth 012/1/20240222
    Car 2BBBMonth 021/1/20242   
    Car 2BBBMonth 022/1/202412  
    Car 2BBBMonth 031/1/20242   
    Car 2BBBMonth 032/1/202472