Hi there,
I would like to show Revenue by Customer by Month in a Table.
Customer should be displayed as Account ID (property of Customer) and I would like to also show Account Name of Customer.
Currently I am struggling to get both. I can select just one property so it is either Account ID that is being displayed or Account Name.
Is there an option to show both?
Best answer by Min Li
In your Customer dimension table, create a new column called Display Name which is Customer.ID & Customer.Name. Then from the setting panel, Default display name with column Display Name.
+1If Account Name is a property in your Customer List, from your Table click on Pivot then Add in the section of the table (Pages/Rows/Columns) and you will be able to select Account Name as an addition member of that report section.
+13In your Customer dimension table, create a new column called Display Name which is Customer.ID & Customer.Name. Then from the setting panel, Default display name with column Display Name.
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
