Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
how can i combine 2 values of Dimension into one?
If bill num ever got the number one return only 1.
I want to see the bill number only one time in the table and at the end put it in KPI.
Hi BarPinto,
Thanks for writing in the Community. Could you, please, better describe your question? I am not sure I can understand what is your goal.
Thanks
hey,
thank you for your reply.
what i meant is in case i have same dimension value ( name ) like the table: both line has the same bill num - PC90000798, but the measure im calculating gives me 2 different values - the calculate is matrix that check if the bill ever been in a status.
how can i make condition that if the bill number ever got the value 1, always return 1 for this bill number ??
today i get: 2 lines
what i want to see: 1 line with the value 1 if ever got 1, else 0 if never got 1.