Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening,
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.
Yes. You can create a calculated dimension.
=Aggr( If(Sum(Sales)>100,' Cat A Customer', 'Cat B Customer')),Customer)
Yes. You can create a calculated dimension.
=Aggr( If(Sum(Sales)>100,' Cat A Customer', 'Cat B Customer')),Customer)