天天看点

Attribute view add column_SAP刘梦_新浪博客

First create Attribute view 

Detail information about creating Attribute view you can refer to http://blog.sina.com.cn/s/blog_c0978c9b0102wcy2.html

Attribute view add column_SAP刘梦_新浪博客
Attribute view add column_SAP刘梦_新浪博客

Add columns

  1. Year
  2. Attribute view add column_SAP刘梦_新浪博客
    Attribute view add column_SAP刘梦_新浪博客
    Attribute view add column_SAP刘梦_新浪博客
  3. Press ok and active
  4. Attribute view add column_SAP刘梦_新浪博客
  5. Show data
  6. Attribute view add column_SAP刘梦_新浪博客
    Attribute view add column_SAP刘梦_新浪博客
  7. Price1Add column price1
  8. Attribute view add column_SAP刘梦_新浪博客
    Attribute view add column_SAP刘梦_新浪博客
    Attribute view add column_SAP刘梦_新浪博客
  9. Save and active,check data
  10. Attribute view add column_SAP刘梦_新浪博客
  11. Price2Add column Price2
  12. Attribute view add column_SAP刘梦_新浪博客
    Attribute view add column_SAP刘梦_新浪博客
  13. if("CARRID"='LH' ,"PRICE"*1.5,if("CARRID"='SQ',"PRICE"*0.5,"PRICE"))

    Save and active,check data

  14. The Attribute view looks like this