Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create ACCOUNTS TYPE column under which there are three sub columns i.e. TAIL ACCOUNT(rev <1 Mn) , MIDDLE ACCOUNT(rev b/w 1 to 5 Mn) and LARGE ACCOUNT (rev >5 Mn)
So I need to compare revenue value in order to create these account types corresponding to the customer groups which might have same customer multiple times having different revenue values. So do I calculate revenue in order to divide them into these three groups and create these columns.
as i understand, you can create cross table for account type and values
result would be like below
Account type, Value
TAIL ACCOUNT(rev <1 Mn),.5m
MIDDLE ACCOUNT(rev b/w 1 to 5 Mn),1.5m
LARGE ACCOUNT (rev >5 Mn),7Mn
I want one column i.e. account type under which there would three sub columns i.e. tail,middle and large.
Hi Pooja,
try
Calculated Dimension :
Aggr(If(rev < 1000000,'TAIL ACCOUNT',If(rev < 5000000,'MIDDLE ACCOUNT','LARGE ACCOUNT)),ACCOUNT)
Expression : Sum(rev)
Regards,
Antonio
Test:
CrossTable(AccountType,Values,1)
Load * inline [
Id,TAIL ACCOUNT(rev <1 Mn),MIDDLE ACCOUNT(rev b/w 1 to 5 Mn),LARGE ACCOUNT (rev >5 Mn)
1,.5,1.5,7
];
Load
AccountType,
Values,
Id,
'Account Type' as header
resident Test;
drop table Test;
take Id, AccountType,header in dimension and sum(Values) in expression
I'm sorry, I add '
Aggr(If(rev < 1000000,'TAIL ACCOUNT',If(rev < 5000000,'MIDDLE ACCOUNT','LARGE ACCOUNT')),ACCOUNT)