Net Sales vs Target Sales

[prabunakil]

Hi i have a qvw which i intend to bring in my target sales which maintain in a excel sheet. 

But when i map it, the target sales is appear at each of the field which i only need it to be place at the last column. Please assist on this. 

Thank You

[lazurens]

If Target Sales is a distinct field remove "Target Sales" from the table's dimensions and keep the measure calculating the target sales.

If you loaded "Target Sales" Concatenated with the "Sales Amounts" use a flag to distinguish rows of Target Sales, and display only the "Sales Amounts"

If(SalesFlag = "Sales Amounts", [Sales Amounts])

Regards,

Mohamed