Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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 .
see attached
i cant use this in set analysis.
because that list i want to see as dimension in the table aslo
see attached.
hope this helps
thank you @Frank_Hartmann but. i dont want other account names in the strihgt table
i want to show only listed customers only.
see attached
in my dashboard i have script like this
how can i incorporate with applymap 😞
Table:
LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Total,
Source,
FROM
$(vQvdPath)/Orders.qvd
(qvd) where Source<>'FA';
LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Total,
Source,
FROM
$(vQvdPath)/orders.qvd
(qvd) where Source='FA';
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
];
Table:
LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Applymap('Map',Account,Null()) as Flag,
Total,
Source
FROM
$(vQvdPath)/Orders.qvd
(qvd) where Source<>'FA';
LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Applymap('Map',Account,Null()) as Flag,
Total,
Source
FROM
$(vQvdPath)/orders.qvd
(qvd) where Source='FA';
Thank you so much. let me check and come back 🙂
USE THIS AS CALCULATED DIMENSION----
=IF(MATCH(Account,'ABB','Accenture','ADVENTIST HEALTH SYSTEM','Limagrain','BOBST','FESTO','SGL Carbon','3M','AGILENT TECHNOLOGIES'),Account,NULL())
USE THIS IN EXPRESSION--------
IF(SUM(Amount1)>0,SUM(Amount1),'-')
-------------------
IT ONLY WORKS IF U HAVE 1 DIMENSION I.E ACCOUNT IN STRAIGHT TABLE