4 Replies Latest reply on Feb 15, 2016 1:02 AM by lei.chen.0

# can you please tell me how i can perform this calculation in tableau desktop.i am new in tableau                                                             Old Value (= OldValueDesc if value exists else = OldValue) New Value (= NewValueDesc if value exis

can you please tell me how i can perform this calculation in tableau desktop.i am new in tableau

Old Value (= OldValueDesc if value exists else = OldValue)

New Value (= NewValueDesc if value exists else = NewValue)

• ###### 1. Re: can you please tell me how i can perform this calculation in tableau desktop.i am new in tableau                                                             Old Value (= OldValueDesc if value exists else = OldValue) New Value (= NewValueDesc if value

Hello rohail khan,

I've moved your post to the Forums as VizTalk is more of a place to share interesting Vizualizations than a place to get assistance with using Tableau Desktop.  The Forums area is the best area for these sorts of questions.

Regards

Patrick

• ###### 2. Re: can you please tell me how i can perform this calculation in tableau desktop.i am new in tableau                                                             Old Value (= OldValueDesc if value exists else = OldValue) New Value (= NewValueDesc if value

As for the question,

If [Desc]="OldValueDesc" then [Oldvalue] else [Newvalue] end

But if you have a workbook with an example, we could provide a more definitive calculation.

Patrick

• ###### 3. Re: can you please tell me how i can perform this calculation in tableau desktop.i am new in tableau                                                             Old Value (= OldValueDesc if value exists else = OldValue) New Value (= NewValueDesc if value

can you please help me out the sorting is not correctly apply on dashboard..not as ascending or ordecending order...like Communication id not in sequence

i'm also apply this like Default Proparties>Sorting...but it's not working

• ###### 4. Re: can you please tell me how i can perform this calculation in tableau desktop.i am new in tableau                                                             Old Value (= OldValueDesc if value exists else = OldValue) New Value (= NewValueDesc if value

Hello ROHAIL,

One solution can be like thus.

1. Duplicate "Communication ID".

2. Drag & drop "Communication ID (Copy)" before (left to) "Audit ID".

3. Sort on  "Communication ID (Copy)".

4. Uncheck "Show Header" for  "Communication ID (Copy)".

Regards.