Want to Create the Field in Data Model

Anonymous — Fri, 06 Apr 2018 04:06:10 GMT

Hi i am having the Requirement to add the Dimension in the Ad hoc Report

1.M Comments

2.Scomments

Based on below two column i need to create the (M Comments & S Comments )field in the Data Model

1.A Comments

2.Sub type

Req1: if sub type ='Supliment' ,it should return the relavent A comments -->Need to create it as field .

Re: Want to Create the Field in Data Model

olivierrobin — Fri, 06 Apr 2018 08:25:30 GMT

hello

why don't you use in your load

if( sub type ='Supliment',[A Comments],other value) as (M Comments & S Comments )