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
- Year
Attribute view add column_SAP刘梦_新浪博客
Attribute view add column_SAP刘梦_新浪博客
Attribute view add column_SAP刘梦_新浪博客 - Press ok and active
Attribute view add column_SAP刘梦_新浪博客 - Show data
Attribute view add column_SAP刘梦_新浪博客
Attribute view add column_SAP刘梦_新浪博客 - Price1Add column price1
Attribute view add column_SAP刘梦_新浪博客
Attribute view add column_SAP刘梦_新浪博客
Attribute view add column_SAP刘梦_新浪博客 - Save and active,check data
Attribute view add column_SAP刘梦_新浪博客 - Price2Add column Price2
Attribute view add column_SAP刘梦_新浪博客
Attribute view add column_SAP刘梦_新浪博客 -
if("CARRID"='LH' ,"PRICE"*1.5,if("CARRID"='SQ',"PRICE"*0.5,"PRICE"))
Save and active,check data
- The Attribute view looks like this