5 Replies Latest reply: May 29, 2014 9:00 AM by Bruno Souza RSS

    Counting Customers with Multiple Products

    Paul Edrich

      Hi and thanks for the help I have searched Help & the community.

       

      My objective is to create a Pivot table which will show a variety of purchasing combinations which Count the transactions completed by each customer in the year the transaction took place, my problem is that I cant get the syntax of the expression correct.

       

      I have a transaction table with multiple products, Fields are - TransID, CustID, TransDate, ProductType I have year as my dimension.

       

      So if Customer 1 had purchased product A (2014) & B (2013) and customer 2 had bought product A (2014) only customer 1 would be included in the count.

       

      My expression Count ({$<ProductType={A,B}>}CustID) returns Product B sales - Even Explicit Count({$<ProductType = p {A,B}>CustID) doesn't return what I expected.

       

      Thanks again.