Using a (self-) calculated dimension with aggr-Function and if-Function possible?
I am wondering if it is possible to do following:
I am having Sales per each Customer. If the Sales is bigger 100, it is a Category A customer, if not Category B.
I would like to have a table which shows me my calculated Dimension (Category A / B Customer) and the amount of Customers. The special thing here is, that the dimension is not caluclated in the DM, I need to let this calculate on Frontend Level in a table.
Is that possible?
I could imagine it is a combination of aggr(sum(Sales),customer) and the if condition if (Sales>= 100, 'Cat A Customer',' Cat B Customer'), unfortunately I dont get this working. Can anybody please support.