1 of 1 people found this helpful
Create calculation as
If [DummyField] = "Capital1" then ([Capital1]]
elsif [DummyField] = "Capital2" then ([Capital2]]
Drag this into text and drag dimension into row.
Don't add sum here because tableau will auto pick up sum.
Thank you. It worked like a charm!
Thank you Sankarmagesh! It is now working the way i wanted it.