Currently, on our monthly Variance reports, it gives the name of the account but not the account number. Is there a way to do a 2nd data view that mirrors to give the account number also?
Thanks
To display both account name and key, I clone the column. Then, set one column to name and the other to key.
5 Likes
Hi @laura.washburn - this Help Center Knowledge Base article describes Amy’s suggestion Display Keys and Names on the Report. Hope this helps!
1 Like
I would usually use an Account column and use Key & Name as output.
Add two blank columns beside the same column and split the Key and Name in two column using Left/Substr/Right functions and hide the Key & Name column on report for more cleaner report presentation.
1 Like