Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
From the table below, I have the Customer and Costs columns as dimensions. What I want to achieve is get a column called Description and assign the following descriptions as shown in the Description column. Please any help on how to figure these out?
Customer Costs Description
HighElectro € 1,924,11 Regular costs
HighElectro € 353,32 Rental costs
HighElectro € 79,33 Connection costs
HighElectro €354,00 Other costs
HighElectro €119,48 Other costs
Thanks.
Hi Simon,
What people would need to know is how each of he descriptions are defined. I.e. if cost is a certain amount then or if it is a certain customer type...
The Logic will be something like
IF( SUM(Costs) > 100, 'Connection costs',
IF(....
Mark
What is the output?
what is the logic for to get description.
please eloberate.
$@m.
The output is the Description Column
where does you description come from?
Regular Costs, Rental Costs
even with an inline table you Need a connect to existing datamodel
can you post your datamodel?
The description does not come from anywhere. That is what I am trying to achieve based on the Costs column.
what is the logic for that.
$@M.
I don't know that is why I am asking help
Do you want to manually assign Description, You can use input field but that will be cleared in next reload?
No I want it to appear per customer selection