#Customer0 人がディスカッション中

Hi Thoa,

I agree with Ken, It does sound as error in Excel. 

You see the difference in results when you added Category, because Tableau is counting distinct number of Customer ID at the level you specified. When there is no breakdown by category, Tableau counts a unique number of customers in the entire database. Once you break it by category, Tableau counts a unique number of customers in each category. It means that some customers placed orders in different categories. For example, if Customer #1 purchased furniture and office supplies, this customer will be counted as unique only once if there is no Category on a row shelf, but will be counted 2 times (once per each category) after Category added.

To keep it fixed at Category level, you can use LOD formula as CustomerCount = { FIXED [Category]: COUNTD([Customer ID])} and replace CNTD(Customer ID) with CustomerCount on a row shelf. This way, if you remove Category from the shelf, it will count the number of customers as Furniture Unique Customers+Office Supplies Unique Customers+Technology Unique Customers.

Hope that helps.

Tanya

Hi Balaji,

16 Columns restrictions are not applicable when you use a customer dimension which has more than 16 members in it.

You can attach the excel workbook after changing your editor mode to advanced by right click on the top right corner of the editor and choose 'Use advanced editor''. Once you are in advanced editor mode, right bottom you can see the attach button.

as I understand you want to export a 'list' of customers who used a specific promotion.

with this kind when an 'order is created' you can store the promo information at a custom attribute of the 'order' level. example custom.appliedSpecificPromo

and using this as a query condition when generating an export/report  file

example

orders = OrderMgr.queryOrders('(status = {0} OR status = {1}) AND  custom.appliedSpecificPromo = {2}', 'creationDate desc',
            Order.ORDER_STATUS_NEW,
            Order.ORDER_STATUS_OPEN,
            'tbd');

from order, you can get the customer via order.customer