Hello All,
I am facing problem in calculating the non profit customers state wise. Attaching the workbook someone please help me.
Please remove customerID from your LOD expressions, dimensionality
e.g. if you want to count customerId in each state expression should be
{fixed State : COUNTD(customerid)}
not
{fixed State, CustomerID : COUNTD(customerid)}
the other issue is that you are using COUNT but it looks like you need to use COUNTD.