Hi, to get the latest ordering date, I think we can get without LOD...just tried..a calculated field..max(orderdate)..giving me same result.....any difference?
Wonderful. Thanks for posting Rajesh. I have one scenario like "How many customers are contribution profit based on Parameter selection". In detail- for ex: If I select 90% in the parameter, the Viz should the list of customers are contributing 90% sales entire the data.
I have data for customer name, contract value, contract start date and contract end date. I need to create the following fields Customer Categories: New Customer: Customers whose total Contract Value increases from $0 before or by the end of the period. Lost Customer: Customers whose total Contract Value decreases to $0 before or by the end of the period. Customer Upsell: Customers whose total Contract Value increases between the beginning of the period and end of the period. Customer Downsell: Customers whose total Contract Value decreases between the beginning of the period and end of the period. New Customer (Reclaimed): Customers whose total Contract Value increases from $0 before or by the end of the period, but which had positive Contract Value at an earlier point in time. Lost Customer (Temporary): Customers whose total Contract Value decreases to $0 before or by the end of the period, but returns in a later period. Can someone please guide me through it?
