Static values

[soniasweety]

Hi All,

@sunny_talwar  @tresesco 

i want to show the top customers  ( these are fixed customers ) in stright table how to show?

the list mentioned in text object.   8 customers only should show in table with amount .

[soniasweety]

Hi @Frank_Hartmann   there is one more catch 

user has given  other dimension Account1   with  two values     

Account1

axa

numeo

he want to show this dimension also in the stright table  how can i include this dimension values in applymap?

[Akhil_Reddy]

USE THIS CALCULATED DIMENSION ON FIELD 2---------------------->

=IF(MATCH(Account,'ABB','Accenture','ADVENTIST HEALTH SYSTEM','Limagrain','BOBST','FESTO','SGL Carbon','3M','AGILENT TECHNOLOGIES'),Account1,NULL()) .

NOW U GET 8 VALUES FROM DIM 1 AND U GET VALUES IN DIM 2 WHICH ARE ASSOCIATED WITH DIM 1

[Frank_Hartmann]

showing only the 2 Accounts in straight table?

Add the 2 Accounts to your Mapping table like this

(Note: QV is Case sensitive. You need to exactly match the notation of your source file for field Account)

Map:
Mapping Load * Inline [
Account, Number
Limagrain,1
BOBST,2
FESTO,3
SGL Carbon,4
3M,5
ABB,6
Accenture,7
ADVENTIST HEALTH SYSTEM,8
AGILENT TECHNOLOGIES,9
Axa,10
Numeo,11
];

As dimensions just use:

=if(Flag=10 or Flag =11,REGION,Null())
=if(Flag=10 or Flag =11,Account,Null())

[soniasweety]

Hi @Frank_Hartmann   sorry  you miss undestood my question 😞

i need to add one more dimension  along with  first dimension aswell

Account i need to show  8 customernames   in account1 i need to show only 2 customers  names in stright table

[Frank_Hartmann · Accepted solution]

see attached